Dynamically changing column header name of a straight or pivot table based on selections made
I have a question - On the top I have months and quarters measure to select, so if Jan is selected, Jan data will be shown and if Quarter is selected, say Q1 then data in dashboard will show Q1 data. Now I have a straight table where columns Months Actual and Month Target are column headers showing actual and target numbers for metrics in the table. Can it be possible that when I click Q1, these column headers dynamically change to Q1 actual instead of month actual and Q1 target instead of month target. SO when I click on Feb or March instead of Q1, these should go back to month actual and month target. Hope I am clear.