Have you tried using an Action filter to do this? Dashboard - Actions on your toolbar. Or you can also place the 2 tables on your dashboard and select 'Use as filter' on the first table you want to act as a filter. This creates an Action filter for you.
I have tried that. With the 2 tables on the dashboard, in this scenario I do not have the menu option of use as a filter
Would it be possible to give us a packaged workbook?
This makes it easier to help you.
Thanks and regards!
What happens if you just create the action using Dashboard - Actions? A packaged workbook would make it far more likely you'll get this question answered promptly.
As for what happens when I add an action.
When I create an action that filters on all fields, I'm left with 1 row of data on table 2. I can't exactly tell what it is filtering. However that is still not what I need.
In the initial post, what I'm looking for is that when I select one of the counts in table 1, table 2 would be filtered for all of the users who purchased Brand X on Order #2. The table then would show all their behavior.
I can't open you file, however can't you alter the action to not filter on all fields, but only on the User field?
Is there an issue with the file that I can fix so that you can open it?
As for the filter. UserID is not a field in the worksheets. UserID is only being counted, so when I try to edit the action based on UserID, I get the missing field warning.
The file is too big for my rubbish internet connection.
Do you have multiple extracts in the workbook and you're trying to action filter across data sources?
Yes. I do have multiple data sources. The action I'm trying to create here is against 2 data sources that are copies of each other. I assumed that would be the right way to go.
No need to copy the data sources for the vast majority of use cases, and seems like no need at all based on my limited understanding of what you're trying to do. Create the 2 tables from the same data source and this should make things far easier for you.
This is achieved by creating a Duplicate of the Brand User ID measure and converting it to dimension.
For the second sheet, you can use the duplicated column of Brand User id from dimension pane to row shelf and purchase cycle on column shelf.
Please let me know if you find this helpful.
Hope this solves your query,