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

      Hi,

       

      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,

      Christian