Formula for subsidiary view item

AntonMineev
Regular Contributor

Re: Formula for subsidiary view item

Are P1 and P5 related hierarchies, composite directories?


First, try opening your module and pivoting so that there are years, P1 level and other dimensions. If you have a sufficient calendar, then the line item for growth may already have the correct values. You just need to set up the correct view.

 

If P1 and P5 are unrelated directories, then it makes sense to create a separate module and repeat the calculation.

JoannaAn
Contributor

Re: Formula for subsidiary view item

Yes, P5 and P1 are the same hierarchy.

 

I was thinking that filtering and pivoting might work.. but I was said that it's not really.

(One of my source's module is flat..that's why..But in L1 and L2 there was no anything similar..)