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
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?
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...