Alternate state issue

[manoranjan_d]

Hi all,

In my UI i have two filters and one straight table

These two filters are defined with state

Filter 1 (field name : primary compare date ) as state 1

and filter  2 (field name : secondary compare date ) as state 2

in the straight all the expression as defined with the two state

example

exp1:

=Only({[state1]}amount)

exp2:

=Only({[state2]}amount)

so the user can make week wise compare

Now third filter needs to be added

example : description field as filter3

suppose if the user select the filter 3(description filed) the data in the straight table wont change as per the filter3 selection bcoz we have declared the exp as state1 and state2, now how  to show the straight table  data with selection of  filter1,filter2 and filter 3  and to make compare the data

let me know any other way to achieve this

attached is the sample file

[devarasu07]

Hi,

Do you want to ignore description field value selection from the report? if so you simply exclude description field using below set expression.

=Only({<[state1],description=>}amount)

=Only({<[state2],description=>}amount)

Tks,Deva

[manoranjan_d]

No,

i want to include the description field as list box in the  UI and according to that the straight table  have to show the records and also week wise compare have to be performed as per the primary compare date  and secondary compare date  filters .

[devarasu07]

Can you try like below,

Is possible to use alternate States with set analysis

[manoranjan_d]

I have attached the file can u provide me the solution for this?

[manoranjan_d]

there is proper solution of your link

[sunny_talwar]

Try this

=Only({[state1]<description = $::description>}amount)

=Only({[state2]<description = $::description>}amount)