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

    Excel Indirect



      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!