Hi Andrew,

I tried with the file, but it didn't recreate. I am trying to use the smartsheet capabilities to set up a report that I can use on both a consolidated basis and on a departmental basis. Ideally, that is, in a perfect world, the ranges I have set up would print the g/l detail with a subtotal, but consolidated would be for the company, and department would be for the department. Because I can't get the department drop down to work on a blank, or for that matter, any report, I don't know if what I want to do can be done in the manner that I am trying to do it. I don't really want to zip my data to you although I do appreciate the offer. Am I correct in my understanding of how this should work ?

Thanks for your help.

Sandra