This content has been marked as final. Show 7 replies
I have a table (lets call it [Sales] where the column headers are named by years as follows: .; .; . 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
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....