Please i am currently trying to create a custom Report for only a selected few categories in my menu. Needs some assistance on how to create this custom report.
Let say i have 10 categories in my menu namely Pizza, Burger, Sandwich, Softdrinks, Wine, Champagne, Soups, Noodles, Salads, Sauce. I want to create a custom report for only this selected categories Softdrinks, Wine, Champagne, .
The Report should be able to provide each individual product in all the selected category i.e ( Softdrinks, Wine, Champagne.)
i. Quatity sold of each individual product in all the selected Category.
2.Amount sold of each individual product in the selected Category.
i will be very glad for any assistance Thank you