5 Replies Latest reply: Apr 14, 2016 12:54 PM by Christof Gruber RSS

    Pivot - background color based on other rows result

    Christof Gruber

      Hi all,

       

      I would like to change the background color of some cells inside a pivot, based on the measure result in another row. So lets say I have the following pivot table:

       

      customerarticleJanFeb
      cust Aart 15002000
      art 21000500
      cust Bart 110001000
      art 2600700

       

      ... I would have the following result:

      customerarticleJanFeb
      cust Aart 15002000
      art 21000500
      cust Bart 110001000
      art 2600700

       

      So the bg color expression should be something like

      If(article = 'art 2', If(Sum([Sales]) < Sum({<article='art 1'>} Total [Sales]), red()))

      ... which does not work :-(

       

      Anyone has an idea?

       

      Thanks, Christof