I have managed to make the chart like a funnel, but I can't get the labelling to do what I want. See my chart below.
Here are my settings:
Expression 1 and 3: (Max(TOTAL Aggr(sum(Value), Category))-Sum(Value))/2
Expression 2: Sum(Value)
I have created a Master item for 1 and 3 and colored it Gray