calculation should exclude everything except

[#1]

Hi,

I have 5 filters like Product, Region, Empname, Site, Month.

When I want to show aggregate number it should change when I click on month.

So I used Sum({<Product, Region, Empname, Site>} Amount) ...its working but I need to mention it in each text box everytime.

DO WE HAVE ANYTHING THAT WILL EXCLUDE EVERYTHING EXCEPT MONTH.

OR

GOOD & EASY WAY

Thanks

narendra

[sunny_talwar]

Try this

Sum({1<Month = $::Month>} Amount)

or

Sum({1<Month = p(Month)>} Amount)

UPDATE: Check this link out

Ignore all selections except some specific fields using Set Analysis

[swuehl]

Maybe have a look at alternate states and only offering the Month listbox to modify the Month selections in that alternate states.