Pivot table - 2 same dimension

[Anonymous]

Hello,

I have a table Year Month, Bucket and RefNOid.

I am trying to build a pivot table with 2 dimensions in it. One with Bucket for current month and second dimension with last month.

I am not able to get the desired output as seen in the attached excel sheet.

Need your help to define the dimensions/ expression to get this output.

[lironbaram]

hi

in your case i think it's better to calculate the previous bucket in the load script

attach is an example

[Anonymous]

Any alternative on how to handle at dimension and expression level at front end ?

[mkelemen · Accepted solution]

Hi,

it is possible - you have to use p() function in set analysis.

Here is quite good explanation Indirect Set Analysis for P() and E()

You can find it implemented in the qvw.

BR,

  Matus