Hi everybody,

[#1]

I have an issue that concerns calculation of total of quantity of two products for all the clients that I have.

I have 'Prdt1' and 'Prdt2'.

I have this expression :

Sum(Total {$1<Product={'Prdt1' ,'Prdt2'}>}Quantity).

but the xpression changes everytime i make a selection. I wanna calculate the total regardless to selections.

Please if anyone can help me I will be very grateful.

Thank u

[Kushal_Chawda]

Sum({1<Product={'Prdt1' ,'Prdt2'}>}Quantity).

[sunny_talwar]

Instead of $1, you just need 1

Sum(Total {1<Product={'Prdt1' ,'Prdt2'}>}Quantity)

Not sure if Total is needed or not

[trdandamudi]

Replace $1 with 1 and you don't need Total in the expression.

[#5]

It doesn't work guys.

I have in addition to product, their segments so when I choose a segment the total changes and I don't want it to change .

I want to have the total of quantity of 'Prdt1' and 'Prdt2' ignoring all the selections I make.

Please Help !!!!!

[sunny_talwar]

Would you be able to share a sample showing the issue? I don't think it should happen, but it could be due to some other unknown reason to us. We might be able to see the issue when you share the sample

[Peter_Cammaert]

If you put your sum() expression in a text box, does the outcome still change with every selection? If so, do as Sunny says and post an example document.

If not, then you're using dimensions that change the output. Chart dimensions are applied after the set is calculated. What other dimensions do you use in your chart, aside from Product? 

[Kushal_Chawda]

Expressions suggested above should work regardless of selection because there is a identifier 1 is used in expression.