Need to show 3 months data in a selected month

[#1]

Hi all,

Please help

I need to develop a pivot chart in which I have show 3 months data for a selected months.

for example if user select jan, then output should be of Jan,Dec and Nov

I have used Month as my dimension and written an expression as sum({<currentmonthstart={'>=(=Addmonths(Max(currentmonthstart),-2))'}>} Call_Ref_Num)

which is not working properly.

Also want to know whether can we use column() function in set analysis?

Ex: sum({<Region={'US'}>} Column(1))

Please suggest.

Thanks in advance.

[#2]

hi,

I think you have a problem in your syntax. Set Analysis with calculated expression need a dollar to be evaluated :

sum({<currentmonthstart={'>=$(=Addmonths(Max(currentmonthstart),-2))'}>} Call_Ref_Num)

but it's just for the syntax, i don't know if the result will be good.

Valentin Bauchet

[#3]

Hi all,

Any updates on this?

Need some help regarding the problem.

Thanks

Amay

[#4]

hi amay,

Please Find the Attached Appln.

I hope this will give a base idea for your data.