Year over Year (YOY) comparison based on Dimensions

[#1]

Hey!

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.

Thanks!

[#2]

Gysbert,

I don't know why but I'm still getting the "Allocated Memory Exceeded" error. I downloaded it many different times. Tried to open it on a couple of colleagues' computers and still got the error. I'm pretty sure we have the processing capacity to run it (we are using i7 processors with 8gb RAM capacity running nothing but the QV application).

Could you please try to upload a different version of it, or maybe some printscreens of the solution?

Thank you a lot!

[Gysbert_Wassenaar]

Uploaded again.

[#4]

Thank you VERY MUCH Gysbert! This is exactly what I needed!