Hi @jemin ,
If you want to add a filter, you have to use LAC-W instead of LAC-A. Keep the previous calculated field to show in the visuals but create another one using LAC-W and use it for filtering purposes.
% values (LAC-W):
sumOver(customers, [topic], PRE_AGG) / sumOver({customers_all}, [topic], PRE_AGG)
Using LAC-W functions for filtering is covered in use case #3 in this article:
[Level-Aware Calculations in Amazon QuickSight]
Level-Aware Calculations (LAC) are powerful functions that allow us to perform calculations at a granularity level which is different from the granularity of our datasets and/or visuals.
The sample dataset referenced by this article is a dataset of product orders placed by customers. Each order can contain multiple products and each product in an order has a unique Line Item ID. Each row of our dataset represents one line item but we want to per…
2 Likes