Good day all
Please can someone help me with a customized group report.
I want to see revenue generated for Food, Shisha, Bottles & Bar.
For example:
Food Revenue Report
Group Name | Quantity | Amount
Main Course | 5 | 1000
Pizza |10 | 2000
Starter. | 7 | 4000
Dessert. | 6 | 1000
Total. | 28 | 8000
Bottles Revenue Report
Group Name | Quantity | Amount
Vodka btl | 5 | 1000
Rum btl | 10 | 2000
Cognac btl. | 7 | 4000
Whiskey btl | 6 | 1000
Total. | 28 | 8000
Bar Revenue Report
Group Name | Quantity | Amount
Mocktails. | 5 | 1000
Cocktails | 10 | 2000
Softdrinks | 7 | 4000
Juices | 6. | 1000
Total. | 28. | 8000
Shisha Revenue Report
Group Name | Quantity | Amount
Apple group. | 5 | 1000
Mint group | 10 | 2000
Flavoured group | 7 | 4000
Total. | 22 | 7000
GRAND TOTAL. | 106 | 31,000
I will be so grateful if the community can help me out with this report
Thank you so much.