Conditional

[Anonymous]

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...

[swuehl]

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

[Anonymous]

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...

[Anonymous]

Got it! It's:

Sum ({<Origen = {"$(=subfield(GetFieldSelections(Origen,'||'),'||',1))"}>}[Amount])

Thanks Stefan!