Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
sum({1}sales)
SUM({1}Sales)
or
SUM(ALL Sales)
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)
Hi
Try like this
Sum({<productname=>} Sales)
or
Sum({1} Sales)
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