Waterfall chart

Highlighted
Occasional Contributor

Waterfall chart

Hi,

Waterfall chart is showing for all values as "Upwards direction" as shown below:

WF_givenresult.JPG

I WAS EXPECTING to be like this below.

 

WF_expectedresult.JPG

 

Does we need to write any expressions/formula to set Net1, Net2, Net3 and NetRevenue to start from 0 instead of prev line item ?

 

Thanks,

Satish.

Message 1 of 2
1 REPLY 1
Contributor

Re: Waterfall chart

Hi Satish

 

What I've noticed you're using components (Gross Revenue, GPO, etc.) as list members with Rebate $ as line item. You should consider creating module with those components as line items (see screen below). This module doesn't have any other dimmensions. In your case you should replicate all additional dimmensions (Time, Versions, Lists) from original module.Waterfall chart.PNG

 All items displayed in black are simple sums of proper items.
Net1 = Gross Revenue + GPO + Fed

Net2 = Net1 + Medicaid

Etc...

Now marking single column from Gross to Net Revenue and selecting waterfall chart should create below chart.waterfall chart actual.PNGHope that will provide help you needed.

Kind regards,

Lukasz

 

 

Message 2 of 2