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

How to Get Cumulative Counts using Special Categories

Started by keerthikarri, 26 Apr 2013 02:20:21 AM

Previous topic - Next topic

keerthikarri

Is there a way to create cumulative count in cubes???For ex if data is like,
Mnth    Count
Jan                           1
Feb                           2
Mar                           3

The cube should provide me the data like
Mnth                           Count                           Cum.Count     
Jan                           1                              1
Feb                           2                              3
Mar                           3                              6

Is there a way to achieve this in the cubes??
I have read somewhere that this can be achieved using special categories in transformer??If so,please help me in achieving it.

Thanks in advance...


jaganlalrm

Try to Create Running total in Cube for Cumulative Count. Like that only i have count in Report Studio.

You help me How to Create Cube. In which i can create  Cube Transformer or Powerplay.

Thanks in Advance