In my report I have HeadAcc, SubAcc, MMM-YY & Revenue. I want to count the number of SubAccs whose first Revenue appears in the current month at HeadAcc level.
I've added a formula for Min(MMM-YY) as FirstRevenue to get:
HeadAcc SubAcc FirstRevenue
1 a Jan-10
1 b Feb-10
1 c Mar-10
1 d Apr-10
1 e Apr-10
I want to show for April:
HeadAcc No.
1 2
I've tried adding a variable of Min(Mnth) and then another variable as a detail of subacc which works when i filter the report on 1 particular head acc but can't seem to get the right number when i remove the filter as it puts the total number in each individual row.
I've tried using various counts with foreach, forall & in to try and solve the context issue but can't get this to work. Can anyone help?