PL Dashboard - Calculations in both Rows and Columns
I need to create a PL report/dash board where there are calculations in both rows and columns as in the attached screen. How can I achieve this.
I have selections for Period, Year, Products and Region. Based on the period and Year selected, the data should show current YTD, prior YTD and % Change. These are part of columns. In Rows I need GL accounts Sales (account), COGS (account) and Profit (Calculated).