15 Replies Latest reply: May 25, 2016 4:57 AM by Stefan Wühl RSS

    Conditional formatting and comparison with the median value in the same pivot table

    Filiberto Cacciari

      Hi everyone,

       

      what I would like to do is to display in the same table the example you see in my excel attached in sheet "TO Display", you can see also the formulas.

       

      I tried to do that in qvw but as you can see in my attached qvw, I'm stopped at the calculation of the % per Buyer/MonthYear.

       

      Do you think that is possible to implement my excel example exactly in the same pivot table qvw?

      Maybe I have to separate some of those information, average or median, in some other table?

       

      Thanks for your help.

       

      Filiberto

       

      stalwar1 gwassenaar swuehl