KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
With this dataset: Category | Amount A | 5 A | 3 B | 6 B | 2 B | 1 C | 7 I want to create a tablix grouping on category, displaying the percentage of the total amount: Category | Percentage A | 33% B | 38% C | 29% Which should be a simple calculation: Category | Percentage A | ((Sum of Amount within group / Sum of Amount across groups) * 100)% B | ((Sum of Amount within group / Sum of Amount across groups) * 100)% C | ((Sum of Amount within group / Sum of Amount across groups) * 100)% But I can't figure out how to do that within Report Designer (SSRS) - whenever I create a row grouping on Category , I can get the sum within the group with =Sum(Fields!Amount.Value) . But how to get the sum across groups from a cell within the group?
Tags (comma-separated)
Save Edits
Cancel