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.




      stalwar1 gwassenaar swuehl