Your percent of total is what's called a Table Calculation. Table calcs are performed on the Tableau Table, AFTER all other calculations and filters have been completed so when you are applying a filter on Brand, the table calc percent of total only knows about that 1 brand so will always return 100%
One way round this is to also make your filters Table Calculations - thus the percent of total applies to the whole data table and then it filters just for your selected brand. To do this, you need to create some calculated fields for each of your dimensions you want to have a filter on. For example, the formula for the Brand Filter should be
This new field is a table calculation. You can then use this as your quick filter instead of the Brand dimension itself.
thanks for your quick response. I have created the filter variables as you advised me. Unfortunately, the created filter variables do not work if I put them all together on one page. I made a detour and created the calculations for each filter variable on each page and connected them to a dashboard.
The problem is that at the end in my Dashboard the views do not share filters, for example: “SoA Brand” works exclusively with “Brand Filter”.
My goal is to create a dashboard where all views react on brand, segment and model filter. Please see the ppt attached.
2. If I select Segment X and Brand A, I see the SoA of Brand A in Segment X (KPI view) , also the Segment Mix for brand A in Segment X (Segment Mix view) and the SoA for brand A in Segment X for each month ( SoA view).
Hmm.. that's a bnit more complex. What I did was a bit of a quick fix for a single view.
To accomplish what you're trying to achieve in a dashboard, I would probably do a combination of duplicating the data (for my total values, as described here: http://kb.tableausoftware.com/articles/knowledgebase/summary-and-detail-60) and making use of Dashboard Action Filters, rather than quick filters, so you can click on a brand name in one view and it updates the other charts in the other views. More info on that here: http://downloads.tableausoftware.com/quickstart/feature-guides/actions_filter.pdf
I have attached a mock up of what I mean in the attached.
Best of luck!
Percent of total.twbx.zip 63.4 KB
This is brilliant, thanks so much!