
1. Re: percentages changes on graphs
Ivan Young Jun 13, 2016 3:11 PM (in response to msa s)Hi msa,
I can't open your workbook but I've experienced this behavior before. I'm not exactly sure why it occurs(I suspect it's when creating the % of total calc needing to = 100%) but I can suggest a workaround. Create a % of total using only LOD and the %'s of the right pane will stay the same when you deslect an item, see screenshots below. Please let me know if you have any questions.
Regards,
Ivan
LOD % of total for subcategory: { FIXED [SubCategory] : SUM([Sales]) }/{FIXED : SUM([Sales]) }

2. Re: percentages changes on graphs
msa s Jun 13, 2016 3:46 PM (in response to Ivan Young)hi Ivan
here is the attachment
when i deselect chairs and charimats it changes the percentages in all bars ,it should not be like that, they should remain constant.
Please correct if what i expect is wrong .
i see % same in all cases ,if i deselect chairs and charimats , i see tables as 31.46% in all cases .Is this right ? then what is the use of Fixed LOD here ?
Please suggest if a misunderstood this part here ?
see this screen shot as per

3. Re: percentages changes on graphs
Ivan Young Jun 13, 2016 3:52 PM (in response to msa s)Thanks for the attachment MSA, I attached is a workbook where the % of totals on the right side do not change. When you filter out a productsubcategory that row will disappear, however it's counts will still be used in the denominator when calculating the % of total. Let me know if you have any questions or if you are trying to do something different.

FixedBars.twbx 1.5 MB


4. Re: percentages changes on graphs
msa s Jun 13, 2016 9:52 PM (in response to Ivan Young)Hi @Ivan
or
someone please suggest
Little confused , could you please explain what is the use of fixed lod here ?
But in other cases you may want the percentages to hold steady even as you filter items in or out. That’s what we want in this case.
In which cases?

5. Re: percentages changes on graphs
Ivan Young Jun 13, 2016 10:47 PM (in response to msa s)Hi MSA,
I'm not really an expert on the way Tableau works but I'll explain to the best of my understanding. When you derive a % of total, SUM([Sales]) / TOTAL(SUM([Sales])), using a table calculation the total will always = 100% even when the data is filtered as the filter is being applied to both the numerator and denominator. When using an LOD to derive a % of total that % is derived on the row level and will not change when data is filtered out of the view, and the % will hold steady.
I also noticed you seem to be applying some table calculation to the LOD you created, this is why your % of total changed when you applied filters. If you just leave it as a SUM the % should not change when filtered..
Below are a few screenshots demonstrating what is happening and the difference
% of Total using a table calculation with the numerator and denominator and no filters. These would be the same values using an LOD to calculate % of total.
% of Total using a table calculation with the numerator and denominator with Chairs & Chairmats excluded. Notice how the denominator decreased by the sum of the Chairs & Chairmats row.
% of total using LOD with numerator and denominator with no filters applied.
% of total using LOD with numerator and denominator with Chairs and Chairmats excluded. Notice how the denominator doesn't change even though Chairs & Chairmats are excluded.
Let me know if you have any questions.
Regards,
Ivan