Whether you deal with papers daily or only occasionally need them, DocHub is here to assist you take full advantage of your document-based tasks. This platform can inlay table in Sales Report, facilitate collaboration in teams and create fillable forms and legally-binding eSignatures. And even better, every record is kept safe with the top security requirements.
With DocHub, you can get these features from any place and using any device.
what if you have date wise sales figures like i have here and you want to calculate total sales for each month or total sales for each course of the year or total sales for each year with the help of pivot tables you can get the desired data in just a few clicks [Music] first of all you will ensure that the column which contains the date data is in the date format then what you will do is that you will click anywhere in your data then click on insert tab click on pivot tables then you can either choose a new worksheet or you can select the existing worksheet i will select existing worksheet here then i will select a location for the pivot table then i will click on ok and here what you have to do is that you have to drag the order date you have to drag the order date field in the rows box and you have to drag the total sales field in the values box and here you have to ensure that the values field calculators sum because there are other options also you can calculate average or count a
