1 of 1 people found this helpful
Could you please attach your sample data as twbx format.
Your underlying calculation is quite a bit complicated and the expected view is not easy.
I cannot re-build all the logic from the scratch (Actually it might be better, but cannot do such on forum) and tried to replicate closer look.
But still not sure this is really correct logic or not, but anyways closer than current.
Both filters to context for LOD to work properly.
Re-calc the height of bar based on the ratio of each cause group
Sample Model_SM_10.3.twbx 1.8 MB
This is impressive. I do appreciate the time you've taken to create a solution, thank you.
Let me try and replicate your results within my workbook and prove it out. Be in touch shortly.
It proves out! You did it!
There is no way, with my current knowledge, that I would've been able to produce these results.
Thank you so very much for your time and effort!