How to let certain tables ignore selection

su_pyae · ‎2022-05-09

Hi everyone,

I have something bugging me. I have 4 tables on one sheet as can be seen from the following photo.

The columns are almost the same in all tables but the measures/formulae are different which is why they are in different tables.

When I select something (for example, Account), said account will be selected in all 4 tables.

I can't do GetFieldSelections( ) since the columns are the same in both pivot tables.

I would prefer it only related table will make changes based on the selection.

Thank you for your help in advance.

vinieme12 · ‎2022-05-09

Use alternate states

There is more content on youtube on alternate states

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.