Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have the following example data:
Year | Type | Product | Amount |
---|---|---|---|
2014 | Forecast | A | 245 |
2014 | Forecast | B | 100 |
2014 | Realized | A | 100 |
2014 | Realized | B | 80 |
2014 | Unforeseen | A | 10 |
2014 | Unforeseen | B | 10 |
Forecast adds up to: 345
Realized adds up to: 180
Unforeseen adds up to: 20
Now I want to create a Block chart with 'Type' as dimension, but the expression should do the following calculation:
Forecast = sum(Forecast) - sum(Realized) = 165
Realized= sum(Realized) = 180
Unforeseen = sum(Unforeseen) = 20
What kind of set analysis or other solution could I use.
See attached example!
Cheers,
Frank
And now?
Is that you need?
Hi Enrique,
Thank for you answer. In your example the variables show the right values, but the block chart does not. It shows 330 for 'Forecast', instead of the desired 165. 🙂
Frank
And now?
That's it!! Thanks!!