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. date company category product value 2022-01 AA A p1 10 2022-01 AA A p4 10 2022-01 AA B p1 3 2022-01 AA C p2 23 2022-01 B…

Hi elrafaraujo! I think I have a solution for you if you dont want to display the Category field in your table. The solution will still give you two Value fields - one that is filtered by Category and one that is not (for your denominator I suppose), but it wont show the Category field in the visu…

I’m sharing your feature request with our product team

Hi @Jesse , could you show your solution in that case? I have the same problem here. Tks

It has been a while since I dove deeply into this, but I found the analysis I and @Koushik_Muthanna were testing this out on. Check this out in DemoCentral (can open the Analysis and look at calcs, filters, etc) to see if it meets your needs. There are a few different sheets with different approac…

Thank you @Jesse . let me take a look and back here soon.

@woliveiras Did Jesse’s solution work for you? Hope so.

Hi @Kristin … sure. It was useful. Thank you

Is there a way to a calculated field ignore only one filter and consider the others?

Q&A

Ying_Wang June 20, 2022, 9:36pm 4

@emilyzhu We might want to consider to support field level filtering.

Pivot Rows and calculations

Topic		Replies	Views
Have some filters apply to my calculated field but not others Q&A filters , quick-sight , calculations , Business-Intelligence-Engineer	6	353	August 5, 2024
Visual filter using calculated field Q&A filters , quick-sight , calculations	12	3988	October 6, 2022
Make calculated field that ignores filters Q&A filters , calculations , Business-Intelligence-Engineer	11	176	April 27, 2026
Calculated field not affected by filter Q&A filters , quick-sight , calculations , Business-Intelligence-Engineer	3	58	October 28, 2025
Ignore some filters from calculated metric Q&A formulas , filters , quick-sight , sum , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer	1	141	July 11, 2024

Is there a way to a calculated field ignore only one filter and consider the others?

Related topics