PL Dashboard - Calculations in both Rows and Columns

Options
selvaam12
selvaam12 Member, ALL USERS Posts: 4 Occasional Contributor
in Planning & Modeling

Hi,

 

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).

 

-- Selva.

Tagged:

Categories