Hi
I have created the following dimension, fixed on client (UP_ID)
Category2
=IF (Aggr(sum([JJ Gerechtsdeurwaarders portfolio value]),UP_ID)>0.00 AND aggr(sum([Print Portfolio Value]),UP_ID)>0.00, 'JJ Gerechtsdeurwaarders AND Print',
if (aggr(sum([JJ Notariaat Portfolio Value]),UP_ID)>0.00 AND aggr(sum([Print Portfolio Value]),UP_ID)>0.00, 'JJ Notariaat AND Print',
if (aggr(sum([JJ Portfolio Value]),UP_ID)>0.00 AND aggr(sum([Print Portfolio Value]),UP_ID)>0.00, 'JJ AND Print',
if (aggr(sum([Print Portfolio Value]),UP_ID)>0.00 AND aggr(sum([JJ Gerechtsdeurwaarders portfolio value]),UP_ID)=0.00 AND aggr(sum([JJ Portfolio Value]),UP_ID)=0.00 AND aggr(sum([JJ Notariaat Portfolio Value]),UP_ID)=0.00, 'Only Print',
if (aggr(sum([Print Portfolio Value]),UP_ID)=0.00 AND aggr(sum([JJ Gerechtsdeurwaarders portfolio value]),UP_ID)>0.00 AND aggr(sum([JJ Portfolio Value]),UP_ID)=0.00 AND aggr(sum([JJ Notariaat Portfolio Value]),UP_ID)=0.00, 'Only JJ Gerechtsdeurwaarders',
if (aggr(sum([Print Portfolio Value]),UP_ID)=0.00 AND aggr(sum([JJ Gerechtsdeurwaarders portfolio value]),UP_ID)=0.00 AND aggr(sum([JJ Portfolio Value]),UP_ID)>0.00 AND aggr(sum([JJ Notariaat Portfolio Value]),UP_ID)=0.00, 'Only JJ',
if (aggr(sum([Print Portfolio Value]),UP_ID)=0.00 AND aggr(sum([JJ Gerechtsdeurwaarders portfolio value]),UP_ID)=0.00 AND aggr(sum([JJ Portfolio Value]),UP_ID)=0.00 AND aggr(sum([JJ Notariaat Portfolio Value]),UP_ID)>0.00, 'Only JJ Notariaat', 'other')))))))
And would like now to do something like this:
Sum({$<[Category2]={'JJ Notariaat AND Print'}>}[Print Portfolio Value])
and plot it in a chart vs.
Sum({$<[Category2]={'JJ AND Print'}>}[Print Portfolio Value])
nevertheless I keep getting the overall Print value and not the one per category..
could someone help me fix it?
thanks!
