Thanks Dimitry for your response.
Yes there is i have already tried that,it gives me correct % only when all filters are selected. when i change something in filter it changes % as well - it appears it shows % of running total but i dont know how to fix that.
I have already attached a workbook !
did i miss anything ? this is first time i'm using this forum so not sure but i have attached sample tableau workbook and s/sheet in question.
This should be the output...
110 Dec-2015 Jan-2016 Feb-2016 May-2016 P1 1.61% 0.00% 0.48% 4.49% T1 0.00% 1.77% 19.42% 18.62% MD1 3.69% 1.12% 2.25% 1.44% 120 P1 0.80% 0.00% 0.16% 20.55% T1 1.77% 0.00% 0.00% 2.73% MD1 0.00% 15.89% 0.48% 2.73%
I do get % but when i put filters on ID, month or charge group it changes the %
OK, now we are finally getting somewhere!
Correctly formulated question is half the answer
- Google search - Google
- 4th item in Top 15 LOD Expressions | Tableau Software
- Replacing No Data with 0 or Another Value
p.s. there's also custom sort on Month and Charge Group just so it aligns with what you've been posting
community.twbx 17.3 KB
1 of 1 people found this helpful
Thank you so much Dimitry... really appreciate your help !