Custom Report for only Selected Categories

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.

  1. 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, .

  2. 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