1 Reply Latest reply on Jun 16, 2015 8:00 AM by Tom W

    How do I create a calculated field that uses values from a dimension to determine what to sum

    Stefan Hanotin

      Hi all,


      I know this must have been asked previously and I did my best to find it but couldn't.

       

      I have a dimension called Category that has 2 values, "Cost of Sales" and "Sales".

      I have measures that are January to December.

       

      I want to calculate the Gross Margin (Sales - Cost of Sales) for each month (measure name).

       

      How can I create this calculated field?

       

      Thanks for the help.