I'm sure the following is a pretty standard request but I'm not sure what I should be searching for.
My team and I are trying to replace our normal excel financial reports with PowerPivot generated ones.
We have an obstacle that we are unsure as to how to over come.
Breaking down values to the next level for certain parents / column headers only.
So if you imagine across the top of the report we have different years (2008, 2009, 2010)
Each of these years has to sub-divisions: "Reported" and "Adjustments" and we currently show financials for each one.
We however wish to break up the "Adjustments" into a further level but we wish to do this by while keeping the Reported column as-is. Furthermore I want the user to be able to select by which field we break out the "Adjustments" column by (ideally) dragging a new field into the field list.
At the moment the field list will replicate the breakdown categories for the Reported column as well.
My team and I are trying to replace our normal excel financial reports with PowerPivot generated ones.
We have an obstacle that we are unsure as to how to over come.
Breaking down values to the next level for certain parents / column headers only.
So if you imagine across the top of the report we have different years (2008, 2009, 2010)
Each of these years has to sub-divisions: "Reported" and "Adjustments" and we currently show financials for each one.
We however wish to break up the "Adjustments" into a further level but we wish to do this by while keeping the Reported column as-is. Furthermore I want the user to be able to select by which field we break out the "Adjustments" column by (ideally) dragging a new field into the field list.
At the moment the field list will replicate the breakdown categories for the Reported column as well.
