Comperative report - two groups using the same filter listbox

[Anonymous]

Hi

I want to compare between two groups that have the same type.

meaning that the field Type (listbox) is a filter for both groups.

I define 2 container and each of them has different state.

But when I select Type (default state/inherit state), it’s not effect on the groups and show all options, which its wrong since I don't want to allow cooperation between different type.

Any idea?

Thanks

Ravit

[ahaahaaha]

Hi Ravit,

May be will you use predefined different states (look example at attached file)?

Regards,

Andrey

[Kushal_Chawda]

You need to use set analysis to have effect of filter sin other state

=sum({[State 1]<Type=$::Type>} Sales)

[Kushal_Chawda]

see this

Is possible to use alternate States with set analysis

[Anonymous]

Thanks but I don't think I can use it. see this picture:

I have two groups (Report A and Report B)

And I need filter on RunID by Type field (PnP, RvR,WMI...)

[Anonymous]

It's not good for me, since I need one field that common for both states. see picture down

[Kushal_Chawda]

I am still not clear, what exactly you want to achieve?

[Anonymous]

By default, listbox 'Run#' show all RunId's.

I want that this list will show only RunID that relevant to Type.

Type is - Multi, RvR, PnP... ( the filed on the top).

And both group should compare the same type.

I want to compare 2 diffrent RunID with the same Type.

[Kushal_Chawda · Accepted solution]

in both state, use below expression in listbox of Run#

=aggr(only({[State 1]<Type=$::Type>} Run#),Run#)

=aggr(only({[State 2]<Type=$::Type>} Run#),Run#)

[Anonymous]

Thank you