I was hoping to build a waterfall and then be able to show how each step was broken down by using the colour by category. However when using the y axis % of total option, if there are 3 categories, the total changes from 100% to 300% which makes the visualisation useless as no body can work out what the % values mean