Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please see attached example. I'm able to create two columns based on selected values, but I'm unable to create the correct conditional sum.... Please advise...
Not quite sure what you are looking for - a pivot table?
Article | Origen | Forecast 2 | Forecast 3 |
---|---|---|---|
1 | 1508 | 1488 | |
2 | 750 | 82 | |
3 | 98 | 48 | |
4 | 39 | 5 | |
5 | 574 | - | |
6 | 874 | 6 |
Not exactly, as I need to add more dimensions... i.e. customers... It's just about the formula of the amounts:
I used Sum ({<Origen = subfield(GetFieldSelections(Origen,'||'),'||',1)>}[Amount]) but it's gives an error.
subfield(GetFieldSelections(Origen,'||'),'||',1) gives the first selected origen, but I'm not able to get the conditional sum correct using this value...
Got it! It's:
Sum ({<Origen = {"$(=subfield(GetFieldSelections(Origen,'||'),'||',1))"}>}[Amount])
Thanks Stefan!