Waterfall - Have a subtotal for first few categories and then have total at end?

[loafers]

Hi,

I have a waterfall chart where I'm starting from last year's revenue and having different categories to walk to my current revenue. 

In the chart below, is there a way to have subtotal of Prior Revenue and Categories 1 to 4 and have it show before Category 5? Basically I want a bar in between Category 4 and 5 below as a subtotal of everything before it. Sample data also included below. 

CategoryAmountSort Order

Prior Revenue	10000000	1
Category 1	-1000000	2
Category 2	1500000	3
Category 3	-500000	4
Category 4	-300000	5
Category 5	2000000	6

[lbendlin · Accepted solution]

It is possible but you need to use custom visuals and you need to massage your data accordingly.

Might be easier to do with Deneb.

See attached.