Hello, Imagine a visual with : date and brand as dimensions and sum(sales) as value. I’d like to add a calculation for each brand : sum(sales (of the reference brand (which is a parameter)). I’m fighting with the syntax, can you please help me ? (the difficulty is, for each brand, to “unselect…

If you say sum({value}) and then just filter the brand to the parameter it will only show the brand that is that parameter’s value. Is that what you’re looking for?

Hello, thanks for your answer, in fact, I’d like to calculate something like this : sum({value}) / sum({value “of a specific value of the dimension, the value is selected by user”}) (We called it a base-100 calculation). To give you an example, suppose we have following data : Brand;Value A;…

How to calculate a total of a parameter value in a visual

Q&A

Koushik_Muthanna June 13, 2023, 10:41am 4

duplicate : How to mix filters and change partition level in the same calculation? - #7 by Koushik_Muthanna

Topic		Replies	Views
How to mix filters and change partition level in the same calculation? Q&A quick-sight , calculations	7	487	May 15, 2023
Visual filter using calculated field Q&A filters , quick-sight , calculations	12	3965	October 6, 2022
Calculated field that uses the same metric twice but ignores the filter for one of them Q&A filters , quick-sight , calculations , Business-Intelligence-Engineer	11	111	November 21, 2025
Is it possible to capture the user selection in filters similar to parameters? Q&A filters , parameters , quick-sight , calculations , visual , Business-Intelligence-Engineer	6	263	November 29, 2023
Combine data using different parameters Q&A quick-sight , calculations	8	422	August 4, 2023

How to calculate a total of a parameter value in a visual

Related topics