topic Re: Single Selection in Piviot table in App Development

Single Selection in Piviot table

zyn — Mon, 14 Jul 2025 13:46:26 GMT

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

Re: Single Selection in Piviot table

anat — Sat, 26 Jul 2025 11:44:53 GMT

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....