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

    Calculated Field based on dimension values

    Jackie Klein


      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).