Hi,
I am create a P&L where I have the GL rolling up into a P&L line which then rolls up into a P&L category.
However, the GL rolls up nicely into the line item but Im struggling to get the line items to roll into the category.
Im using metrics to populate my line items rows and dimensions for GL and Category -
In the screen shot I want the GL 60110 to roll up to Core Processing and for this to roll up to Revenue.
But instead it simply duplicates the Core Processing line.
Here are the summary settings -
The metrics feeding this table are dimensioned by P&L Line Item (as a dimension), P&L Line item category (property of P&L Line Item) and GL
I have mapped GL level data to a line item in a dimension and then mapped this to the individual metrics so I can present it in a table.
Please explain how I might be able to achieve what Im looking for.