Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a piviot table, in its raw state there shouldnt be any default selection, but when the user selects a value from chart and when he selects any other value from the chart it should take only current selection and deselect previous selection, is there any way to achieve this!
Thanks
give a try using pick and match along with GetCurrentSelections
=pick(WildMatch ( GetCurrentSelections(),'*Region*','*YearMonth*'),1,2)
then in the table create 2 measure if output of above expression 1 then bypass Region etc....