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,