Skip to Content
0
Former Member
Oct 31, 2005 at 06:50 PM

Sales for the last X months

18 Views

Hi Gurus,

I have to create a report which will display the sales for the last X months. Now I want the display to be month-by-month in separate columns and the user to will enter the value for X. I know you can do a restricted key figure by restricting sales with 0calmonth and then creating other columns using Variable offsets. But can we display the sales for the last X months or even any given X months dynamically (not knowing the no.of months the user might enter).

Please help.

Thanks,

Ashmith Roy