sql server reporting services: The data cell contains '=iif( Fields!dt.Value <
#11/1/2004#,"*",Sum(Fields!MyValue.Value))' which is causing the subtotals
(row & column) to show an * whenever the row or column shows an *.

How do I get the subtotal to ignore the *'s and subtotal on just those cells

I discovered that the subtotals cell is using the Fields!dt.Value from the
first matrix column, and since the columns are sorted oldest dt to newest the
dt.Value is < the date indicated.

Can someone think of a way I can fix this other the changing the column order?

[quoted text, click to view]