don't want to show same period last year data in a different column

[singhcv123]

Hi,

I am using pivot table and calculating current,previou and same period last year data in table.

as given in below screenshot i want the data in financial year 2016 not in 2015 ... because i selected 2016 in list box...

what to do .

Set expression for :

This Period :sum(Count)

Previous Period:Sum({<[New Period Code]={$(=if([New Period Code]=1,13,[New Period Code]-1))}>}Count)

Same Period Last Year :Sum({$<[New Period Code]={$(=Num([New Period Code]))},[Financial Year]={$(=NUM([Financial Year])- 1)}>}Count)

please suggest.

[MK_QSL]

Provide data to work !

[tresesco]

Two ways are there I can suggest.

•      In the script, create another column with last year data. Check :The As-Of Table for idea.
•      In the UI, use pick()/match(), possibly in combination with synthetic dimension Valuelist()/Valueloop()

Both the ways have their pros and cons.