I would like to make a calculated field which is a fixed percentage of itself, aggregated by category AND respect the others filters of date, company and product.
I created the calculated fields:
- value by PRE_FILTER = sumOver(value, [date], PRE_FILTER)
- value by PRE_AGG = sumOver(value, [date], PRE_AGG)
For example, when I filter company = “AA” in January 2022, value by PRE_AGG gives me the expected answer of 46. In February also gives me the expected answer of 22. I would like to fix these totals whenever I filter the category at the same time it is dynamicaly filtered by the others filters of date, company and product.