Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it possible to restrict the values available in a chart via set analysis, but then allow the result to still be filtered on by the user?
e.g.
Department:
Finance
Supplies
Corporate
Expression:
=sum({<Department = {'Finance','Supplies'}>}cost)
This expression would sum the cost for Finance and Supplies, excluding Corporate. If I then wanted to filter down to Finance by selecting it in a list box, it would not alter the sum.
Is there a way to make that happen?
Thanks in advance.
Tom
This:
=Sum({<Department *= {'Finance','Supplies'}>}cost) // if you want to filter down to finance on selection
Your current expression should not alter the sum actually. Do you want it to just show Finance when you select Finance or still show both?
This:
=Sum({<Department *= {'Finance','Supplies'}>}cost) // if you want to filter down to finance on selection
Your current expression should not alter the sum actually. Do you want it to just show Finance when you select Finance or still show both?
Hi Sunny,
Yes, I just wanted it to show finance if finance is selected.
The new expression gets highlighted with a syntax error, but it works as I want it to.
Thanks
I had same issue..but why sometimes the set expression seems to allow me to delve into the subset of filter , in this case "France" , but sometime it does not... I thought that $ sign always allows to select other dimensions...only 1 is to lock.