Hi, I have a sheet that has the following fields:
Product Name, Product Price, Ordered Qty, Ordered Date (DD/MM/YYYY)
As you can image, the users would have any number of transactions per date. Thus, I wish to provide the user with the option to display transactions of placed orders in a report like grouped by two options: 1) by Date of transactions, 2) Per Month transactions. I was wondering what the best approach to do so. (i.e. QUERY Function or pivot table ) and which would you recommend knowing that there will a large number of records per user.