sum if - based on calculated dimension

[kyt_karen]

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!

[brunobertels]

Hi 

you can't use a calculated dimension in a set analysis