What are you trying to do in there with   MIN({SUM([Sales])})  ?

That value is getting calc'd at the entire database level, regardless of the dimensions on the sheet.  (2,297,201 is the number you get, no matter what subcategories you select.)

I think I see what you're trying to do.

The unselected sales bar is the sum of sales that the user has NOT selected in the filter on "Chart".

You can't pass a measure in an action filter.  Only a dimension.  And what gets passed (if anything) is what was selected, not the absence of a selection.

It's going to take a hack, if it can be done at all.

Curious problem.  I'm seeing if I can figure something out.

This gives you sales amount for the unselected categories

SUM({ FIXED : SUM([Sales])})-SUM([Sales])

But the drill-down doesn't work because

1) actions work on dimensions not measures

2) For unselected sales, there is no corresponding sub-category (as it wasn't selected in quick filter) to drill down the bottom grid.

Hope this makes sense

Hi Kate,

This is little bit tricky, and the final view is not very fancy. but still operation-able from my perspective.

(" Always show" needs to be selected always literally. ==> add "space" to the left of "Always" to keep top position o the filter. )

Thanks,

Shin

Kate -- What I tried doing was messing with the action filter that gets added to the "Detail" sheet when I create an action that passes Sub-Category.  You can do some things to that pill, and what I tried doing was changing it to an EXCLUDE filter once it got added to the "Detail" sheet.

On the first click it actually did what I wanted.  I had the "Chart" sheet passing all the sub-catetgories that were selected, and the modified action filter set to EXCLUDE was actually showing everything that was NOT passed.  However it seems Tableau doesn't like that.  Once I cleared the filter, (by de-selecting what was clicked on the "Chart" sheet), it reset the action filter on "Detail" so that it stopped working.

Therefore, follow through with what Shin is doing in his reply.

Sorry my fault.

This filter should n't be the context.

If the posts helped, please mark answer as correct / helped to close the thread not from inbox but from original post.

Thanks,

Shin

HI Kate,

It's completely different, not follow up at all.

Please post new thread with clear expectations.

Thanks,

Shin