I m am trying to create a sheet which has a table with columns like pc_visits,mobile_visits etc. however i want the measures to change based on the filter pane selection between PC and Mobile (as a filter pane object in the same sheet)
So basically, if the option PC is selected the Table should be
Site sum(PC_visits) sum(pc_minutes)
if option mobile is selected, the table should be
Site sum(mobile_visits) sum(Mobile_minutes)
The two solutions i could thing of were using If else but thats not an efficient approach when the data scales. The other option was to modify the dataset in a way such that both measures for PC and Mobile are in same column with a separate flag column separating them. However it is a pain for me to do that.
Is there something i can using set analysis or something to solve this