4 Replies Latest reply: Feb 23, 2016 7:24 AM by Reinhold Graf RSS

    background-color dependent on several conditions

    Reinhold Graf

      Need to set the background color of an article number in a pivot-table dependent on the following conditions

       

      - number of customers (distinct) >= X

      - quantity >= Y

      - sales€ >= Z

       

      For a KPI-figure, i used the following:

      count({<Menge = {">=1000"}, KundeNr = {">=25"}>} KundeNr)

       

      But for the background, I have no idea, how to set up a formula with multiple conditions

       

      Reinhold