Dynamic Subset with Expand Above
Posted: Tue May 15, 2018 12:48 pm
Hi,
I'm working on a dynamic subset and couldn't figure out what's wrong.
I have a P&L dimension.
(Net Profit)
> Revenue
> Gross Exp
Now there's a special request in that they want to see:
(Net Profit)
> Revenue item 1
> Revenue item 2
...
> Revenue
> Gross Exp item 1
> Gross Exp item 2
...
> Gross Expenditure
So the way I create this is using dynamic subset, turn on Expand Above, expand all the items and move the "(Net Profit)" from bottom to top.
Problem is: after saving it the "(Net Profit)" went back to the bottom.
I have seen other subset successfully doing what I need here but can't figure out how to do it.
Any advice is appreciated, thanks!
Kenneth
I'm working on a dynamic subset and couldn't figure out what's wrong.
I have a P&L dimension.
(Net Profit)
> Revenue
> Gross Exp
Now there's a special request in that they want to see:
(Net Profit)
> Revenue item 1
> Revenue item 2
...
> Revenue
> Gross Exp item 1
> Gross Exp item 2
...
> Gross Expenditure
So the way I create this is using dynamic subset, turn on Expand Above, expand all the items and move the "(Net Profit)" from bottom to top.
Problem is: after saving it the "(Net Profit)" went back to the bottom.
I have seen other subset successfully doing what I need here but can't figure out how to do it.
Any advice is appreciated, thanks!
Kenneth