i created the a table data where few columns are static and 3 columns data is changing as per the selection in slicer, but is there any way where i can change the headings as well along with the data,enter image description here
I am getting the data by below code, but not able to change headings dynamically, is there any option where i can change headings along with data:
Data 1 = SWITCH([Selected Scenario],”API COGS”,SUM(Table1[API RMC]),”Formulation COGS”,SUM(Table1[Formulation RMC]))