Hi, Kindly Clarify me on the Below Scenario

[Anonymous]

I having list Box below as

Year,

Quarter,

City,

State,

And in Text box i am Showing the Sum Of Sales,

The Question is ?

1)IF i select the Year and Quarter the Sales Value Should Change

2) IF i select City and State Sales Value should not Change

How can i achieve it with the SET Analysis.

Thanks in Advance.,

[sunny_talwar]

May be like this

Sum({<City, State>}Sales)

[sunny_talwar]

Or this

Sum({<City, State, Year = p(Year), Quarter = p(Quarter)>}Sales)

[its_anandrjs]

For ignoring City and State from Sales try

Sum({<City=,State= >}  Sales )

[Anonymous]

Hi  Sunny,

Value is Changing When i select the State and City

[sunny_talwar · Accepted solution]

Do they still change if you use this expression?

Sum({<City, State>}Sales)

[Anonymous]

Hi Sunny,

Just now i have tried this Expression It is working