5 Replies Latest reply: Jan 29, 2015 2:55 PM by Gysbert Wassenaar RSS

    Pivot table calculate with hidden values

    Beaulieu Mathieu

      Hi,

       

      I have a pivot table with four years.

      With expression i calculate sum of "Livraisons" (deliveries).

      After, i calculate the difference (delta) with the year before (last column). To do this i use below() function.

      It works if i don't use filters years...

       

      Example without filters:

      Capture 1.jpg

      Now i want to filter on 2014 and 2013 :

      I use Below function and the result for 2013 is I have an empty value.

      How can i use below with hidden lines?

       

      Thanx for your help.