Skip to Content
0
Nov 19, 2013 at 12:57 PM

How to de-aggregate values in WEBI?

783 Views

Hi,

I have a below requirement in one of my report but i am unable to figure it out how to do it.

Records from infoprovider:

Dist Channel Sales Org Frequency Month Value date year DS1 SO1 Monthly 30 10 01/01/2013 2013 DS2 SO2 Monthly 30 20 02/01/2013 2013 DS3 SO3 Monthly 30 30 03/01/2013 2013 DS4 SO4 Monthly 30 40 04/01/2013 2013 DS5 SO5 Monthly 30 50 05/01/2013 2013 DS6 SO6 Monthly 30 60 06/01/2013 2013 DS7 SO7 Monthly 30 70 07/01/2013 2013 DS8 SO8 Monthly 30 80 08/01/2013 2013 DS9 SO9 Monthly 30 90 09/01/2013 2013 DS10 S10 Monthly 30 100 10/01/2013 2013

when i take it in WEBI report it is showing like below:

Dist Channel Sales Org Frequency Month Max Average DS1 SO1 Monthly 300 100 55

But i need to get the values like below:

Dist Channel Salesd Org Frequency Month Max Average DS1 SO1 Monthly 30 100 55

in Month column i need to get 30 not aggregated value 300. please help me how can i achieve this?