Skip to Content
0
Former Member
Apr 16, 2010 at 09:05 AM

Web Intelligence Count Issue

26 Views

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?