Alternate States Issue with Dim filter across states

[marcoyukon1]

two states:

• State 1
• State 2

two measures:

• SUM({"State 1"} Price)
• SUM({"State 2"} Price)

two dims:

• Year 
• ZipCode

two filter panels: Filter panel 1 only with Year 1 (State 1 ) and Filter panel 2 only with Year 2  (State 2)

ZipCode I need it to be global. but If I apply the filter on Zip Code it won't apply to both measures and it won;t reduce the table rows to only show the zip code selections made on the dim.

There are other "shared dims" that need to be applied to both states at the same time upon selection on a table for price comparison, therefore ading these dims to each state's filter panel for each state will be very impractical.

--

Table:

ZipCode, Year, Price P1, Price P2

I tried applying to the sheet the state, but it will only one Or the other state.

How do I apply a dim filter that will work across all states ?

Thanks

[justISO]

Hi, make 'ZipCode' filter without states, and modify measures, where states are used, to take 'ZipCode' as 'global':

SUM({"State 1" <ZipCode=$::ZipCode>} Price)

SUM({"State 2" <ZipCode=$::ZipCode>} Price)