Don't know if this is the right way to fix the issue we have with the COUNTD problem, but I found a workaround to solve this. Tableau experts can verify this. Attached workbook had couple sheets (Bad One) and (Workaround).

Bad One:

- Running Total of the COUNTD looks fine (2nd mark)

- When the Percent On Total calculation was done on (3rd Mark), it looks like the values are more than what they should be. When Percent of Total is calculated, it is computing CNTD(Item) at the bin level/CNTD(Item) instead it is using CNTD(Item) at the bin level/Total CNTD items.

- With that when the cumulative sum (4th mark) is done the total is > 100%

For ex. bin (-2000) should have been 1065/2958 ~ 36%, but instead it is doing 1065/1263 ~ 84.32%. 1263 is the CNTD(Item).

Workaround:

What I have done is here is on the cumulative sum (4th mark), instead of using the Percent of Total on the secondary type, I have used the Percent From option and selected Last option for 'Display the value as a percentage of'. What this does is it will compute the values based on the last value which is 100%.

Hello, back again. The original solution worked well because it was a running total, but trying to display the % of total COUNTD in a table gives the same problem. Any ideas for a workaround for this? For example, in the sample workbook we're using:

That was the main issue that was messing up the cumulative values. If you look at the workaround sheet from my earlier attachment, 3rd mark has the % of total which was not right. Adding them was giving > 100%. I can look at this later tonight.