Thanks for the response, but I'm afraid it's not quite what I'm looking for. What I would like to see is the Region Sales column filled in for every product, even when the Sales column is blank. For example, I know that the Microsoft Natural Keyboard Elite has sales in the West region (in Arizona and Washington), so when I select California I expect the Sales column to be blank and the Region Sales column to show $1018, which is the total sales for that item in the West. Currently it shows both columns as blank because I've filtered on a state that has no records, so Tableau doesn't acknowledge the sales from other states.
Bumping this back up... Any thoughts on how to tackle this would be greatly appreciated.
There is no Marks on a view (and rows in the datasource)
that correspond to some combination of the Dimension values.
So one need to build such a view -- or the datasource(s).
I've used a self-blend approach.
Brought the [Product Names] from the Primary datasource --
to have a full list of values (a "complete domain" so to say).
And aggregated only California Sales from the Secondary --
using the [State Parameter] as the selector of both filters.
It may look a little bit weird,
but it doesn't require a special "Scaffold" datasource.
Please find the attached.
Hope it could help.
Null when filtered_YF.twbx 1.6 MB
That's perfect! Thanks, Yuriy!
1 of 1 people found this helpful
Jacob, you're welcome.