Current month vs last month
19 August, 2016
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
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
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
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