Hello Gurus,
I need my crystal report to display data as below:-
Net Sales
PG1 Current month Previous Month Prior year-month %Variance
Panels $ $ $
Frames
Can anyone kindly suggest formula for generating these values?
I have already formulated current, previous, prior year months' start dates and end dates.
Further details:-
Data filters are requested for Company-->Region-->Customergroup-->All Product group
Datasource is Universe
Reporting for 2 years data
Your suggestions and help will be much appreciate.
Thanks,
Prarthana