4 Replies Latest reply on Jun 29, 2015 11:59 AM by David Pires

    Calculate within a dimension pt2

    David Pires



      Hope you can help me.


      I've attached a workbook and what I'd like to be able to do is to calculate between those two years, but those two years can change, i.e. they could be 2009 and 2020.


      In excel I'd do something like


      x = 2014/2013*100.


      One thing i seem to be struggling in to know the syntax to calculate within specific dimensions.


      Thanks in advance