1 of 1 people found this helpful
If Category Balance (Before/After) is a dimension then you can simply turn on subtotals, check out the following link to see how:
If Before is it's own measure and After is it's own measure, then you will have to create a calculation that combines them together: [Before] + [After]. Then just add that measure as a third value.
Let me know if you get it to work!
thanks for the reply. Before and After is a single dimension field (say Balance), which gets split based on the category level as before and after (above picture). However, the Balance field is placed neither on the column shelf nor on the row but on the 'Text' under 'Marks' to get numbers listed in the report. When I right click this Balance field in 'Marks', I don't see sub totals.
Analysis -> Add sub Totals and then go to Category level and right click and choose sub totals.