ignore all selections except one, but control selection through a listbox

[#1]

Hi All,

I have three filters in my dashboard. One is GOR, the other one is branches and the third one is desk. I am taking the sum of clients, but sometimes, the client might want to ignore two selection and only consider one selection in the count. However, it should be dynamic and the user should have a control of which one to ignore and which one to chose.

I have created another listbox and put the field names of the other three listbox as its values (GOR, Branches, Desk). However, I am not able to create an expression for the count so that the user controls through listbox which selection to be considered in count and which ones to be ignored

count({1}ClientID) is currently ignoring all selections. Can someone please help in this expression. I can explain more if needed

Regards

Arif

[#2]

Hi Arif

You can use normal expression. You already have a list box with the three dimensions, if a user makes selection only the records realting to the selection are aggregrated hence the other two would be ignored.

Hope I made sense.  If you need more help, Kindly send sample data in  excel or qvw.

Thanks

Fahad  Khan

[jagan]

Hi,

Try like this

-Ignore Dimension1

=Sum({<Dimension1=>} Sales)

-Ignore Dimension1 and Dimension2

=Sum({<Dimension1=, Dimension2=>} Sales)

-Ignore all dimensions

=Sum({1} Sales)

Hope this helps you.

Regards,

Jagan.