With the following two expressions I want to sum all sales from all Ship To's under it's respective Sales Catalog Section as well as count the records of Ship To's for each. So, only include records that had Device sales, records that had Extract sales, etc. I know saying "*" gives me all Ship To's, but I would have expected it to consider the Sales Catalog Section it's under? And yes, I do need the total at each record because I will eventually use these two expressions in another record level expression. What am I missing?
That work great swuehl, thank you! I had over simplified it though in my example. I do need to use set analysis I believe because I also need to specify the previous two fiscal years, all months, and all ship to's. WIth your help, this is what I have now that works: