2 Replies Latest reply: Oct 25, 2014 2:57 PM by Christian Kjønsvik RSS

    Problems with refering to other period i Pivot Table by using Set Analysis



      I currently have a Pivot Table where I have the 4 dimensions where the last one (Period) is moved to a column dimension. I'm trying to add a expression for comparing a field Billable_Hours against the last Period without any luck.


      I've tried to add a expression like this to see if I get it working (Refer to a specific period before trying to add any calculated reference):


      Sum({<Period = {'Uke 42'}>} [Billable_Hours])


      The problem is that this returns 0 for all other Period columns than the one named "Uke 42".

      Anything I'm missing here?


      Thanks in advance,