Alternate state with Other Filterbox selction

[#1]

Hi,

I’m trying to use Alternate State on Straight Table chart, but Straight table should also respond to other Lists boxes.

e.g.,

My Detail Straight table has Status Listbox (which is Alternate State) and this Straight table should also respond to other list boxes like Country, Month, etc.

  I have used non aggregated columns (Dimensions) in the Expression.

Please help!

Thank you

[sunny_talwar]

Would you be able to share a sample to show what you are trying to do?

[#3]

Hi, Thanks for the response.

Bottom right 'Dim1' has alternate state and linked with Table 2.

Table 2 is a Straight table with Dimensions as expression.

I'm expecting Table 2 should respond to Dim 1 (Alternate State) and also to Dim 3 (inherited)

[sunny_talwar]

So for instance if you select X in Dim3 and A in Dim1, you would want to see only 1 row where Dim1 = A and Dim3 = X?

[#5]

Yes, if I select X in Dim3 and A in Dim1, you would want to see only 1 row where Dim1 = A and Dim3 = X

[sunny_talwar · Accepted solution]

Check the attached

[#7]

Fantastic, Thank you so much!

Regards, Sri