I m facing a problem regarding dynamically changing the header label w.r.t to the filter value selection.
I have attached a file in attachments
My requirement is that whenever I select a value from filter pane for eg. I select a value FY18 Q1 then the reflection in the pivot table should be like "Current Quarter projection(FY18 Q2)" column of pivot table should change to "Current Quarter Projection(FY18Q1)", "Recent completed Quarter(FY18 Q1 )" column should change to "Recent Completed Quarter(FY17 Q4)" , "Previous completed Quarter (FY17 Q4) " should change to "Previous Completed Quarter (FY17 Q3)" and similarly "Previous Year(FY17)" should change to "Previous year (FY16)" [Shift one before]. This all should happen along with data corresponding to the all columns i.e the value also should change with the respective headers.