Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi all,
Any updates on this?
Need some help regarding the problem.
Thanks
Amay
hi amay,
Please Find the Attached Appln.
I hope this will give a base idea for your data.