Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
hi
in your case i think it's better to calculate the previous bucket in the load script
attach is an example
Any alternative on how to handle at dimension and expression level at front end ?
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