Skip to Content
Nov 09, 2017 at 04:08 PM

How do I set totals in a Designer 2.0 waterfall graph?

535 Views Last edit Nov 09, 2017 at 04:13 PM 2 rev

I have created a BW query that yields the following result.

Previous YTD 0.375
Non-Packaging Material Costs per YD2 0.047
Packaging Material Costs per YD2 0
Labor Costs per YD2 0.001
Variable Overhead Costs per YD2 -0.027
Fixed Overhead Costs per YD2 0.029
External Processing per YD2 0
Additive Costs per YD2 0.002
Intercompany Markup per YD2 0
Unspecified Cost Comp per YD2 -0.029
Current YTD0.398

I have created a Designer application, added the data set, and I'm attempting to configure a waterfall graph. As long as I use a managed OLAP connection, I'm able to choose the waterfall chart type. I initially get what I expect.

I go to chart configuration and try to set my two total columns by right-clicking one of the columns that should be a total.

The software renders the following.

I'm trying to get the following.

Thank you for your help.


o5smw.png (17.3 kB)
fgfd0.png (8.7 kB)
wg8wf.png (84.7 kB)
e30pf.png (20.2 kB)