‘Common’ selections available to all states

[lampshadedreams]

Hi, 

I have a dashboard with two sheets. 

Sheet A:

1. User Filter
2. Year Filter
3. Month Filter
4. Funds Filter
5. Funds Chart -> Sum(Funds)

Sheet B:

1. User Filter
2. Year Filter
3. Month Filter
4. Spent Filter
5. Spending Chart -> Sum(Spending)

The Red items are common filters whereby if a selection is made in one sheet the same selection should be made in the other sheet.

However the Blue and Green filters are to only select data in their respective sheets. (i.e if Funds Filter is selected the spending chart in the next sheet should not be impacted)

I tried setting up Alternate States for each sheet but then the common Red filters are not available across the sheets.

Any idea?>

[sunny_talwar · Accepted solution]

Assuming your state name on Sheet A is AS1.. you can try this

Sum({AS1<User = $::User, Year = $::Year, Month = $::Month>}Funds)

[lampshadedreams]

I think that worked!

I created a straight table to verify the data on Sheet A:

User	Year	Month	Funds

However, I am not sure how I would apply the same to straight table. Do I apply set analysis to each expression in the straight table (each column) or to just the dimension?

[sunny_talwar]

Each expression where you want the selection to driven from AS1 except for Month, Year, & User which are driven by default state