Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Provide data to work !
Two ways are there I can suggest.
Both the ways have their pros and cons.