Hi, I am currently working in a project with a car company. They want
me to create a table which cummulatively adds previous months sales.
Like March sales figure should have the sum of Jan + Feb + March. They
want me to do this in Power Play transformer. Please help me as I am
not having the luxuru of time for doing this.
Thanks
Nitin

Ensure you have a proper time dimension defined and use a relative time
category. If you use the date wizard, by default you will get a YTD, MTD,
QTD (year, month, quarter to date) categories. Specify the first day of one
particular year properly and the product will take care of all of the
rollups for you. End users will just need to either filter on YTD or add it
to the report to get the desired result. Cheers
ya

"Nitin" <nitinwork (AT) gmail (DOT) com> wrote