2 Replies Latest reply: Sep 6, 2016 3:50 AM by Tresesco B RSS

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

    Virendra Chawra

      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.

       

      screenshot.png