How to get the values row wise in pivot table

[#1]

Hi ,

Can anyone let me know how to get the values row wise in the pivot table. Am attaching xls for your reference.

Please reply if you need any more information.

Thanks and Regards,

Smitha

[#2]

Hi,

  You have to write set analysis to getting values for Currentmonth, previous month, before previous month.

[abeyphilip]

Hi Smitha,

You can assign the values for current , previous and month before in the load and then use these variables in expression (probably set analysis). You will have to use one expression each for the 3 diff months,

Regards,

Abey