Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Waterfall chart with multi measures

Hi,

We are in BI 4.1 SP5.

I need to build waterfall chart.

Currently i have data in following format

MonthMeasure1Measure2Measure3Measure 4Measure 5
Jan5052-203090
Feb2445-102080
Mar6034-154577

I need to have waterfall chart for each month

Since waterfall chart is allowing 1 measure, I am not able to build it.

Please advise how to build the waterfall chart in webi

Regards

Ben

Former Member
replied

Hi Ben,

Just so you know, if you see the image I've in my post, there is an overlap between Measure 2, Measure 3 and Measure 4 which is not how a Waterfall Chart should work. The reason for that overlap is because the sample data you provided has Negative (-ve) values for Measure 3 and hence the bar goes down instead of going up.

Make sense?


Thanks,

Mahboob Mohammed

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question