I have a list report on which i've applied grouping on 2 columns and applied total on one fact column.
Strangely , instead of getting subtotals and grandtotal per group....I'm getting only grand total value displayed on all the appropriate groups !!!
Can anyone ran into this issue before....please suggest.
If you apply the aggregation function (total) first then group, you will not automatically get the totals at the new grouping level. You need to apply the grouping first, then you apply the total, a subtotal will automatically be created at each grouping level.
Actually my issue was because of modeling.....inbetween dimensions table ( grouped columns table) and fact table ( aggregate table) there were around 2-3 bridge tables. Because of this FM is giving strange results.
I somehow found an alternative table and directly joined it with fact table.