If you regularly work outside your workplace and accomplish tasks on the go, then DocHub is the document editing service you need. It’s a cloud solution that works on any internet-connected device, and you can work with it from anyplace. The interface is intuitive yet powerful, so you’ll need only a couple of minutes to Wipe table in Sales Report and make other necessary updates.
Stop wasting time searching for an ideal document editor; explore DocHub today and prepare your forms no matter where you are!
[Music] hello everyone in this video we will talk about how to use pivot table to analyze a three-year sales data I hope you watched our previous video where we consolidated all three years data files into a single file which can be further used to create a pivot table and analyze the data set right now we will be working on the consolidated file thats called three year sales so I go to sheet 1 lets take a moment to look at the data sets on the header front we have sales date region customer type so we have three year sales data starting from 1st Jan 2016 we are selling sports equipment and I can see the business segment and the category along with that I see price quantity the sales amount and finally the discount percentage offered now first thing I do is I select the data set then I go to insert and then Im going to click on pivot table now make sure that all of your headings are having some content if it is a blank the pivot table will not let you proceed so for now let me get b