Year over Year (YOY) comparison based on Dimensions
I'm trying to create a Pivot Table which show the actual (Real) and planned (Plano) values, as well as their comparisons - for some parameters. The parameters are calculated expressions, whereas the distinction between Real and Plano - and hence their comparisons - are the dimension of my table. The following picture shows what I WANT to create (the last two collums are the comparisons).
So far this next picture is what I HAVE, where Real 14/15, Real 13/14 and Plano 14/15 are the components of the Plano/Real dimension.
Could someone help me on how to calculate the comparison collunms, based on the table I have already. Btw, I want the comparison collumns to be on the same "level" as the other collumns.
Re: Year over Year (YOY) comparison based on Dimensions
Make sure the machine has enough ram available. About 25 MB should be enough for the example I posted. If that's not the problem then try downloading the document again. Perhaps it got corrupted the first time you downloaded it.