Calculating percentage of a column in SSRS

Vote count:

0

I need help with showing the percentages of my nr of customers as per the below table. Basically, it counts customers on each fee point and I want to show the percentage of the total count of customers. How do I do that?

In this case, I cannot use SUM for my total count of customers. What do I write so that I can show the percentages for each fee point of the total?

Fees column| nr of Customers  | % of total
Fees       | COUNT(CUSTOMERS)|
**TOTAL**  |COUNT(CUSTOMERS) | 

I have tried these expressions:

=COUNT(Field!nrofcustomers.Value)/COUNT(Field!nrofcustomers.Value)*100
=COUNT(Field!nrofcustomers.Value)/COUNT(Field!nrofcustomers.Value,"tablix1") <- where tablix1 is the table name
COUNT(Field!nrofcustomers.Value)/COUNT(Field!nrofcustomers.Value,"textbox62") <- where my textbox62 is the total count of customers

asked 1 min ago

data addicted

8

Calculating percentage of a column in SSRS