Waterfall chart with multi measures in webi BI 4.1 SP5

Hi,

If you want to add multiple measures in waterfall  we have to convert into pivot format. Because waterfall chart is allowing 1 measure, Its not allow multiple measure.

For this scenario, after converting data into pivot format, its possible to display multiple measures in waterfall chart. See the below screenshots.

Query for Pivot table

DB DATA

Converted into our required format using unpivot  keyword in query