Geek Answers Handbook

SSRS share of total

I would like to be able to get the percentage of each row in relation to the whole amount. Here is my formula:

=COUNTDISTINCT(Fields!ID.Value, "NameOfRowGrouping") / COUNTDISTINCT(Fields!ID.Value, "TopLevelGroupName")

The percentage that he gives is the percentage between the total and the sum of each group:

 Group Qty % --------------------- Group 1 MemberA 3 40% MemberB 4 60% Total 7 Group 2 MemberC 2 50% MemberD 2 50% Total 4 Grand Total 11

I need to know the percentage with the total relation for all groupings, for example:

 Group Qty % --------------------- Group 1 MemberA 3 30% MemberB 4 40% Total 7 Group 2 MemberC 2 15% MemberD 2 15% Total 4 Grand Total 11 100%
+4
source share
1 answer

It looks like you want to do, calculate based on a dataset, not a grouping of tables:

 =CountDistinct(Fields!ID.Value)/CountDistinct(Fields!ID.Value, "MyDatasetName")
+11
source

More articles:


All Articles