Pls give me set expression for this scenario?

[#1]

I have a table   like

TABLEA:

productid,

productname,

sales

i have a chart with these dimension using  pid,pname as a dimensions and  sum(sales) as  expression

My requirement is when i go for  click on product name chart should nit get any changes?

Pls write a expression for this?

[Gysbert_Wassenaar]

sum({1}sales)

[MK_QSL]

SUM({1}Sales)

or

SUM(ALL Sales)

[CELAMBARASAN · Accepted solution]

Hi,

If you want to ignore all field selections in dashboard, you can use

Sum({1} Sales)

If your need is like to restrict the selection happens only in product name field then

Sum({<productname=>} Sales)

[MayilVahanan]

Hi

Try like this

Sum({<productname=>} Sales)

or

Sum({1} Sales)

[SunilChauhan]

remaining as you are using

only expression use this

sum({<productname=>}sales)

not sum({1}sales)  it will hide other selections also

hope this helps