Do you "need" it all on one worksheet? You could create two worksheets that you line up next to each other on the dashboard and for the two filters you want to affect both apply to multiple worksheets.
Right, Hope. Tableau treats the whole sheet uniformly. A filter applies to the whole thing.
The other thing to do is to have the column values controlled by parameters. You can create a calc for one column that takes Parameter-1 into account, and another calc for column-2 that takes parameter-2 into account... But if the filters are supposed to be multi-select, the parameter idea isn't workable.
@Hope Stiles & @Joe Opplet,
Thank you so much for the suggestions. Yes, I have done the both possible ways as you mentioned, 1)Creating Parameters and apply the calculations 2) Split into two different sheets.
The ways I mentioned above is not letting me to achieve my below requirements at the same time.
I'm doing the comparison dashboard. So, Below are part of my requirements :-
1) Cascade the filters
2) Calculate the percentage difference between col A & Col B
1) If I split the sheets cascading the filters is working but i can't achieve percentage difference.
2) If I apply the parameter way, I can't cascade it but percentage difference is possible in this approach.
So, That's why i asked this questions. I will be so happy if i achieve my both requirements in any possible ways.
Your suggestion or help will be much appreciated.
You might have conflicting requirements here.
I'd like to take a stab at what you have. Can you work up a sample of your data and sheets and upload a packaged workbook?
Sure, Joe Oppelt.
Let me ready my sample workbooks & get back to you quickly. Give me some time