I think this expression should do it:
Count( Aggr( If( Sum( [Project $]) > 10 , 1) , [Account Name]) )
First give a tally of the sum of projects for every account that exceeds 10 - then count them.
To be able to have nested aggregations you will have to resort to Aggr() - unless you have a TOTAL qualifier.
Thanks!!! That Worked.
But shouldn't the expression be Count( If(Aggr( Sum( [Project $]), [Account Name] )>10,1))
I'm not sure how your expression with the IF nested inside the Aggr is giving the same result as the expression above ?
Is there a way to plot a chart directly from the Pivot table ? Right now I have to recreate the measures ?
Is there an efficient way to do the pivot and aggregations in excel ? Not everyone in my team uses QlikView.