I have a Table the contains the following column.
- Client Name
- Date Purchase
Is it possible to display the output on this way.
Client Name Date Purchase Quantity of Product A Total Amount of Product A Quantity of Other Product Total Amount of Other Product.
The Idea is to separate the quantity and total amount of a product A from other Product.