I'm having some issues running my daily consolidated system menu items sales detail report. Currently We have different specials on every day of the week that require different prices for menu items. For that reason I have created a different menu level for each day. The items that are on special have a menu item class of "price shift". Before the different menu levels were created I was able to get a total of each item sold because it was all under the main menu level. Now when I run the rport I have to add up the items sold myself because they're listed by day. For an example I sell one cheese stick for a certain price on monday menu level, three on Tuesday menu level, four on Wednesday and so on. I want to be able to look at the total sold for that menu item on my menu item report. It's a pain adding up the totals for each menu level on all of the days to get a total sold. Essentially I want the grand total listed after the different menu levels for each item. Is it possible?
Thank you
Thank you