PivotTables question

[msexcel]

Hi there,

I am confused about this problem, I mean what exactly it mean? Here is what it says: to use PivotTables to find the number of sales transactions by PRODUCT AND REGION, total revenue by region and product. Well, since either by product or region, the order to drag into the row field is different. If by product to find the number of sales transactions, then the order to drag the headings need to be PRODUCT, then transactions numbers; otherwise, it should be REGION, then transactions numbers.

Or, does the statement indicate the heading orders already? I mean it is suppose to be by product, then region to summarize the data?

Thanks,

 

[oldchippy]

Hi msexcel,

There are plenty of examples, tutorials and videos here, perhaps this will help?

http://chandoo.org/wp/search/?q=pivot tables tutorial