Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
Can anyone please give an advice on how to do the following...
I have loaded a database table like follows:
| Factory | Part | Cost | Selected in fieldlist |
|---|---|---|---|
| A | X | 10 | Yes (Part fieldlist) |
| B | X | 11 | Yes (Part fieldlist) |
| A | Y | 9 | Yes (Part fieldlist) |
| B | Y | 13 | Yes (Part fieldlist) |
| A | Z | 7 | Yes (Part fieldlist) |
| B | Z | 6 | Yes (Part fieldlist) |
| A | U | 4 | No |
| B | U | 7 | No |
How can I make a waterfall out of this table? I want to show the total costs for each Factory at the left and right, and the differences in the middle?
Dimension values needed: 'Factory A','Part X','Part Y','Part Z','Factory B'
Values for the dimension: Sum(<$Factory={'a'}> Cost), 1 (green),4 (green),-1 (red), Total cost factory B.
If I choose to select part U as well, I would need the waterfall to include this value as well... Is this possible? 
The dimension part is the most challenging, as I am aware that I can use set analysis to get the correct dimensions. Also I am aware of the offset-technique for creating the waterfall.
Hello and thanks for the response
I will try and illustrate what I need. See the attached file. This was based on another example found on the site, but it is not dynamic... And I have to construct the data in a table during load.
Is it possible to allow for a dynamic version of this (where the factories total costs are calculated (based on selection of costs to include) and displayed in each end, and the costs displayed as a waterfall, bridging between the two factories?
Best regards