Nested Set Analysis??

[Anonymous]

Hello

Attached is an issue i am trying to resolve and was hoping somebody may have an answer to.

I have two dimensions 'Team' and 'Month' and the following expression;

=IF(SUM({<Month={3}>}Sales)/SUM({<Month={3}>}Calls)<0.3,NUM(SUM(Sales)/SUM(Calls),'#,###%'))

What i want is if the percentage for 'Month 3' for any 'Team' is below 30% then return the results for those teams for each 'Month'.

i.e. 'Teams 101 and 103' have a % below 30% in 'Month 3' therefore i want to display 'Teams 101 and 103's' results for 'Months 1, 2 and 3' and not display 'Team 102' at all.

Many thanks in advance.

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[Anonymous]

Thank you G Wassenaar, i didn't even think of the AGGR function!!!!