I want to share my dashboard to reader in pivot table and there is lots of row
that’s why i want to let my user use ‘focus only on..’ but seems that it will effect the filter,
Is there any other way to use it without disturbing the filter?
Hi @reiokabe,
Yes, “Focus only on …” is a shortcut for adding a filter for the selected value.
Could you please elaborate a bit on what problem those filters cause in your use case? If it has to do with calculated fields, you might want to have a look at the Order of evaluation in Amazon Quick Sight. It will also show how you can run certain calculations at the prefilter level.
@Thomas Thank you for your response.
I’ve successfully resolved the data selection challenge by utilizing the interactive features.
This allows me to select and display only the specific data needed.