Conditional Formatting Issue when Nested row

[cognos05]

Hi ,

I have a report which has business days in row and few fields on column and a measure on intersection .

The report is sliced by 4 regions .

Now i have a conditional formatting on the fact cells corresponding to business days level row .

The expression says rowcount()=Query1.Count

Query.Count contains the value of the current business day , so if today is 5 th business day the crosstab is now highlighting the row 5 with conditional formatting .

Now instead of using a slicer i nested the row before the business day level and the same conditonal formatting works only for first region row 5 and not for other regions.

I understand since i now nested business days with region it generates more rows and the day 5 for other region will have different row numbers.

So how do i make a conditional expression that would apply a formatting to all 5 th business day row under any region .

Thanks,