That is a good suggestion, yet we were testing the limitations of Report Builder and have run into a few similar to this. The users current product gives...

It is a layer in the matrix.

Hello,

We have tried that and it does return the second level (as a first level) very well. It seems to be a combination of the two together...

Just to expand I am looking to present the following for any particular month. :

Reporting on January 2007

MTD-JAN 2007 MTD-DEC 2006 YTD-JAN 2007...

Much thanks, as this is the feeback that verifies my testing to date.  

I may not have fully explained the concept.   I would like to force a user to enter a specific account number.  This will, in effect, prevent them from "accidentally" returning every...