4 Replies Latest reply: Oct 1, 2016 11:09 AM by Berk Armagan RSS

    How to show Last Value on pivot insted of Expression

    VICTOR HUGO DE SOUSA ROSA

      Hi guys

       

      I'm having a problem with expand/collapse

       

      I have a pivot table, with month/week as dimensions.

       

      I want to show the last week value, instead of the expression by itself, when i choose to collapse it

       

      Is there any way to to that?

       

      Example:

       

      Month (collapsed)

      50.000

       

      Month/Week (expanded)

      20.000 / 10.000 / 10.000 / 10.000

       

      I want to show 10.000 instead of 50.000 when i collapse [the explression is a sum()]

       

      The real number is "Stock Cost". That beeing said, when i choose to collapse, i dont want to see the sum, i want to see how the month ended

       

      Thanks!