I have need to create a report similar to the below example. Can you please explain how this can be achieved?
Calculation: Sample store data as reference however added an year to the order date..
Quantity = Number of Items Sold
Sales = Total Sale Amount
Discount = % Discount
Actual Discount is derived by percentage and Sales amount
|FY 2017||Jan 2018||Feb 2018||Mar 2018||Apr 2018||FY 2018|
For the above table. All the FY columns need to have the total for the year divided by number of months (Average). where as for the current year, I need to split and show the actuals.
I can separately calculate the columns and add them to the view however the challenge is that every time the month changes -- next month needs to be added automatically for the current year data.
Example - when I move to June date, May column should be added automatically next to Apr.
Looking for some suggestions from the experts. Please advise.
Would you be able to provide some sample data?