2 Replies Latest reply on Apr 12, 2012 5:26 AM by Dereck Wate

    Inserting calculations within a dimension

    Dereck Wate

      i have a simple question if i have two dimensions and one measure

      A) Account Description

      Sales

      Variable Costs

      Fixed Costs

      B) Year

      2009

      2010

      2011

      2012

      and one

      Measure - amount

       

      how do calculate the following

      1. Sales less variable costs = Gross Profits

      2. Gross Profits less fixed costs=Net Profits

       

      Appreciate your feedback