Sum based on Sum({Set Analysis})

[avantime]

Hi,

I want to calculate the Sum of Revenue where

Sum(

{$<

[Product group]={1},

[Invoice date]={"$(='>=' & num(date('01/06/2017','DD/MM/YYYY')) & '<=' & num(date('30/06/2017','DD/MM/YYYY')))"},

[Client profile]={'Valued'}

>}  Revenue)>=100

Any ideas?

[avantime]

Thank you very much Stefan, this is just what I needed!

[avantime]

P.S. Had to add:

=Sum(

{$<

OrderID = {"=Sum({<ArticleGroup={14923},

InvoiceDate={'>=$(=num(makedate(2017,6,6)))<=$(=num(makedate(2017,6,30)))'},

ClientProfile={'Ldmtrhg Gtmrzhs'}>} Revenue) >=99 "},

ArticleGroup={14923},

InvoiceDate={'>=$(=num(makedate(2017,6,6)))<=$(=num(makedate(2017,6,30)))'},

ClientProfile={'Ldmtrhg Gtmrzhs'}

>} Revenue)

As the result showed the total value of the order instead of the total value for valid products.

Thanks again!