If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Grouping - grand totals

Started by cognosun, 25 Jul 2012 02:28:15 PM

Previous topic - Next topic

cognosun

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.


tjohnson3050

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.

cognosun

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.