Search results

Hi All, I'm want to create the Pop-up too, any sample file that I can refer to? TQ

Sorry forgot to attached the link for the file. https://www.dropbox.com/s/e3fz7hv9vqf0hts/Book2.xlsx thanks

Hi all, Can I have the formula to calculate the average of order / quantity. The sample as follow: thanks onncheng

Dear Faseeh, Noted and thanks for your help.

Hi Faseeh, Thanks for the sample file provided. I have created a pivot table as below: https://www.dropbox.com/s/n1rq6ytcxapm4zg/Simple%20Pivot.xlsx There are some questions I would like to ask: 1) How to updates/revised the data after pivot table has created? 2) For the chart which I...

Hi All, I'm would like to create a pivot table with chart, but unsure where to start from. Example: I have ordered groceries items from Supplier A and would like to know: 1) the price fluctuation by date for each items. 2) the total quantities ordered Date Items Qty...

Hi, 1 more file, need to create pivot table for: 1) most order items by quantity 2) most expensive items thanks a lot https://www.dropbox.com/s/k3gpp507em2pvlo/stock%20count2.xls

Hi, I have tried to create the pivot table but look like something incorrect. I would like to create pivot table for: 1) report by category 2) Top 10 item by quantity 3) Top 10 item by price 4) Lowest item Anyone can help me? I'm running out of time :( Thanks a lot...

Thanks Hui. Can you assist me further? I just started to learn and use Pivot Table. https://www.dropbox.com/s/etvsnftckwgwn2t/Book1-pivot%20table2.xlsx TQ

Hi Hui, I tried it and there is one line only and the "sales after changed of menu" details not appear. It will be great if you can log into the file and comment again. TQ

Hi all, I have created a pivot table - comparison sales before and after changed of menu. I'm not sure the whether the table is correct or not and how to create chart as well. Appreciate if anyone can assist me. Thank you https://www.dropbox.com/s/juety35lr1eosx4/Book1-pivot%20table.xlsx...

Hi Faseeh, I would like to work out a chart to compare the sales before and after changed new menu. The new menu started on 03/02/13. Example:Feb 2013 1) 01/02/13 -$1000 2) 02/02/13 -S1220 3) 03/02/13 -$1300 4) 04/02/13 -$1900 5) 05/02/13 -$2000 Thanks onncheng

Hi Faseeh, Do you have any sample file to share? TQ

I'm from F&B (Restaurant) line and need to prepare some reports for the management. I'm looking for reports such as Excel Dashboards 1) total monthly sales analysis 2) items food summary, top 10 items sales analysis 3) suppliers summary and etc. Do you have any templates related or how can...