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

Showing last 4 weeks with cumulative Year totals

Started by antexity, 10 Jul 2013 10:25:49 AM

Previous topic - Next topic

antexity

a

blom0344

I think 2 possible can be tried:

- Hide data you do not want to show but that is part of the dataset (otherwise cumulatives are not properly calculated)

- Feed a second query with the first cumulative one and try if you can use the proper filter on the 2nd query

These are just my 2 cents, can't really test if they will 'cut the cake'

antexity

#2
a

blom0344

The blankness is due to not setting an explicit aggregate for the measure..