Dynamically changing column header name of a straight or pivot table based on selections made

[#1]

Hi All,

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.

[settu_periasamy]

Hi,

i think you are talking about label. if so, you can achieve thru if or match function.

like, in the Actual Expression Label

=if(GetSelectedCount(Month),'Month Actual',if(GetSelectedCount(Qtr),'Qtr Actual','Month Actual'))

in the Target Expression Label

=if(GetSelectedCount(Month),'Month Target',if(GetSelectedCount(Qtr),'Qtr Target','Month Target'))

find the sample attached.

[jonathandienst]

You are on the right track, but you can simplify the expressions:

=if(GetSelectedCount(Qtr),'Qtr Actual','Month Actual')

=if(GetSelectedCount(Qtr),'Qtr Target','Month Target')

These are functionally identical to those yo posted.

[#4]

Thank you settu and jonathan. I will definitely try the approaches. Thanks again