Conditional Format For Clls In Matrix For Values Not Exist In The Db

Hi,

I'm calculating matrix including totals in the database.
I would like to set a background color for all total cells.
For total cells with now dat in database I fail to put codiotional formating.
I use the following code:
=iif(Fields!Col1Desc.Value="Total", "#60759b", "Transparent")
For cells under "Total" columns that do not got any db value I got color "Transparent" and not "#60759b"

How do I recognize to which column or row a cell belong in a matrix even if it not a value that come from db but empty one?


for example, note the background color of the cell of Male, Total and 2006

I got that matrix:











Year


Gender
Employee Status
2006
2007
2008
Total

Male
Active
0
0
1
1

None Active
0
0
3
3

Total
0
7
4
11

Female
Active
6
5
5
16

None Active
5
3
7
15

Total
11
8
12
31

Instead of that:











Year


Gender
Employee Status
2006
2007
2008
Total

Male
Active
0
0
1
1

None Active
0
0
3
3

Total
0
7
4
11

Female
Active
6
5
5
16

None Active
5
3
7
15

Total
11
8
12
31