3 Replies Latest reply on Mar 1, 2018 5:09 AM by Zhouyi Zhang

    Working with Grand Totals

    pavan kumar

      Hi All,

       

      Capture.PNG

      I need to apply two conditions.

      1) Sub Categories : If profit ratio > Total(Profit Ratio) Then Good else bad.

      2) Grand Totals : If Grand Total > 0 Then Good else Bad end.

       

      I need to format them using Colors and Shapes (Good=Green UP Arrow, Bad = Red Down Arrow)

      If you see above image Conditions are not working for Grand Totals.

      I tried to do it in multiple ways but no Luck.

      Any Help?

       

       

      Thanks

      Pavan Kumar