7 Replies Latest reply: Jan 29, 2016 8:07 AM by Tejinder Bamrah RSS

    Excel Indirect

      Hi,

       

      I have a table (lets call it [Sales] where the column headers are named by years as follows: .[2015]; .[2016]; .[2017] etc

      (thus [sales.2015]; [sales.2016] etc)

       

      I have another table (Parent) which has year going downwards i.e. column name = [Year], fields = 2015,2016,2017 etc

      (thus [Parent.Year])

       

      I want to be able to put the Parent.Year field as headers on a pivot and sum from Sales table column which equals to parent.year field

       

      sort of like this Sum( $(='Sales.' & Parent.Year & ']' )

       

      except this formula doesnt seem to be working....

       

      please help!