Set analysis OR instead of AND

[frankhuning]

Hi all,

Maybe a simple question for you developers but for me it's quit difficult as a newby.

My pivottable has an expression like:

Sum

( {$< PROJGROUPID = {"GENERAL"}, CATEGORYID = {"ZZGEN"} >} QTY)

What I try to achieve is the sum of all records where RPOJGROUPID = "GENERAL" OR CATEGORYID ="ZZGEN".

Thanks in advance for your help.

Regards,

Frank

[#2 · Accepted solution]

Hi,

You can try this,

Sum( {$< PROJGROUPID = {'GENERAL'}>} QTY) +
Sum( {$<CATEGORYID = {'ZZGEN'} >} QTY)

[kuba_michalik]

Or you could use sum of sets:

Sum( {$< PROJGROUPID = {"GENERAL"}>+$<CATEGORYID = {"ZZGEN"} >} QTY)

I have no idea whether this is an aesthetic choice, or if it has some performance implications.