Pivot

Hello Rafael
Thank you for your question. I assume you want to know how to create a pivot table?

First ensure that each column of data has a unique heading so the first row of the sheet should be heading row. Next select a place on the worksheet where you want to put the pivot table and click in that cell. Next go to Data, Pivot table and Pivot Chart and a wizard will appear. Click next on the first window as it should automatically be set to pivot table. The next window wants you to tell it the range of data you will use for the pivot table. Highlight all the data on the worksheet that you want to use. You can do this by clicking in cell A1 and holding the mouse button and dragging to the last cell you want to include. Click next once you are done. You will then be given the option to put the table in the same sheet as the data or a seperate tab. Make your choice and click Finish.

Excel will then place a table on your worksheet, but you will need to tell it what data goes where. A list of all the columns will be given in the field list. Click on a field and drag and drop the field on the left side of the table. In the attached example I want to show the total sale value broken down by country so the country goes in the left box and the sale value goes in the middle.

This will create your table for you. Since I dont know what data you will be using or what you want to show it is best for you to experiment with placing the fileds until you get the data you want. You can put more than one field in the left box if you want it broken down by more than one column.

Please see the attached example. Please note that there are lots of different ways to format your table and you can change the summary data from sum to a count if you want to know the number of sales per country rather than the total sale value per country. Try double clicking on parts of the table to see the options.

You can also change options in the wizard to add a chart rather than a table etc.


If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress