Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am trying to add sum of values in a table for my income statement.
below every group I am trying to add a SUMof values above.
The colums groupbreak have a unique combination for each group.
I am not sure how to use these.
Solved! Go to Solution.
Hi @ahsanlhcgov
I would recommend using Matrix visual instead of Table, then you will have required aggregations.
Regards.
Pavel
Maybe I don't understand clearly what you want, but what about pic below? Isn't it what you want?
Regards.
Pavel
Hi @ahsanlhcgov
I would recommend using Matrix visual instead of Table, then you will have required aggregations.
Regards.
Pavel
i have tried the matrix visual but its the same thing. rather then adding the groups it shows the individual value as total.
I am looking for a way to categorize the group break values and then adding ActualYTD and BudgetYTD.
If I get that then which ever visual I use will work.
Maybe I don't understand clearly what you want, but what about pic below? Isn't it what you want?
Regards.
Pavel
I have created a new column and concatenated all the froup breaks and used that as a filter in matrix. Thanks alot for advising to use the correct visual.
Do you need help?
yes like that.
but I have 4 groupbreak colums which work as a unique identifier to determine the category needed to be summed up.
how did you do that, may be I can try to do the same on my data set.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |