Forum

This content is now out of date.

Visit Our Community

Current month vs last month

Hi,

My data in FSales
Product amount month
A 100 jan
A 150 feb
A 200 mar

Can built report?
Filter Periode : feb
CurrMonth LastMonth %growth
Product A 150 100 50%

Ths
Hello,

Can you explain exactly what you are wanting to achieve?

With some more information, we should be able to put you on the right path!

Best regards,
Pete
Example my data in file FSALES
Product;amount;invdate
A001;200; 1 jan 2016
A001;200;15 jan 2016
A001;300; 2 feb 2016
A001;500; 10 feb 2016
A001;1000; 3 mar 2016
A001;1000; 1 apr 2016

How to create report Growth by month ( use filter month ) ?

Filter : feb 2016
Product..currentMonth...LastMonth..Growth
A001.......800............400........100%

Filter : mar 2016
Product..currentMonth...LastMonth..Growth
A001......1000.............800........25%

How to create report?

Ths