Urgent help with waterfall chart!

[Anonymous]

Hi all!

I need to build a waterfall that has the following tags as categories (please check 3rd column below) :

TAG "GO" = Adjusted EBITDA + Nova Rubrica

TAG "Net Final Balance" = Cash Generated From Operations + Investment+Net Initial Balance+Others +Income Tax+Net Amortization+Dividends Payable

TAG "Gross Debt"= Net Final Balance + Net Debt

I am not able to build the graph as the client asked. I am getting the first view, but I would need the second. It's possible? I marked with an X what I would like to eliminate and circled what I needed to show.

What I got:                                                                             

 

What I would like (a customer built this on excel and sent to me):

Breakdown                                       Values (MM) Category          Order

Adjusted EBITDA	14576,31	GO	1
Adjusted EBITDA	1312,71	GO	1
Adjusted EBITDA	1164,27	GO	1
Adjusted EBITDA	-440,39	GO	1
Adjusted EBITDA	-1471,32	GO	1
Cash Generated From Operations	13919,55	Net Final Balance	2
Cash Generated From Operations	1151,61	Net Final Balance	2
Cash Generated From Operations	1218,73	Net Final Balance	2
Cash Generated From Operations	-592,06	Net Final Balance	2
Cash Generated From Operations	-129,75	Net Final Balance	2
Investment	-1536,21	Net Final Balance	2
Investment	-3598,16	Net Final Balance	2
Net Initial Balance	8176,18	Net Final Balance	2
Others	-1762,34	Net Final Balance	2
Others	352,8	Net Final Balance	2
Others	506	Net Final Balance	2
Others	-834,27	Net Final Balance	2
Others	-676,36	Net Final Balance	2
Others	-440,52	Net Final Balance	2
Others	-978,69	Net Final Balance	2
Others	307,81	Net Final Balance	2
Others	146,97	Net Final Balance	2
Others	126,5	Net Final Balance	2
Income Tax	-1050,56	Net Final Balance	2
Net Amortization	0	Net Final Balance	2
Dividends Payable	-3495,85	Net Final Balance	2
Net Final Balance	10811,39	Gross Debt	3
Gross Debt	13199,37	Gross Debt	3
Net Debt	2387,98	Gross Debt	3
Nova Rubrica	427	GO	1

[v-lid-msft]

Hi @Anonymous ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft]

Hi @Anonymous ,

We can try to add a sort column to meet your requirement:

Best regards,