Hi,
I figure I’m overthinking this but have run into an issue. We are creating one workbook for over 5k users. Each user has a unique OrgID which is the first filter applied. So if I’m an org called Rusty’s Cats with OrgID 3360, it filters all other orgs out. This OrgID is part of the Embed code so each different org can only see their totals. On the dB it’s floated to the right because users will not be able to use/see it.
I also want the Min, Max and Average for the metric selected (adoptions, Transfer, etc). That is working using a PCategory Parameter. Now I want the user to select multiple states to update ONLY the Min, Max and Average dots while keeping the orange dot unchanged (so they can see how to stack up against other state, etc). In the workbook, when selecting CO, the max is 1734 but I want to select CO, KY, AZ, etc and that total for the dot should update.
The state filter is on the sheet but because OrgID is also on the filter page and used in the embed code, it is not allowing the multiple state to be selected (that’s expected) so I’m looking for a way to still use the OrgID on the Filter area but still allow the user to select multiple states.
Attached is the data and workbook. It’s a subset of a larger set for all states.
Thank you
