6 Replies Latest reply on Sep 8, 2013 1:38 AM by Steve Martin

    Calculated Field based on dimension values

    Jackie Klein

      Hello,

      I'm trying to modify the calculated field for Profit Ratio in the attached workbook.  I want to modify it so that it only displays the Profit Ratio if the Category = Furniture, and the Sub-Category <> Tables.  For all other values, i want the profit ratio to show null.

       

      I want the Sub-Total for Profit Ratio for Furniture to be displayed, and the Grand Total as well (these two values should be the same).

       

      Thanks!
      Jackie