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.