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.
