gadiyasunny
New Member
I have some data that has the following columns:
Date, vendor name, invoice number, invoice date, amount and sales region.
I want to make a pivot that will show me the location wise details of sales.
In addition to that I want the pivot to give the details of sales in the following buckets:
0-1000, 1001-5000, 5001-10000, 10001 and above.
These buckets will consist of total of all invoices which individually fall in the buckets.
For example if I have three five invoices with amounts as follows:
400, 800, 2000, 3000, 8000.
Then the pivot should show me the following details:
Region 0-1000 1001-5000 5001-10000 10001 and above
Amount 1200 5000 8000.
Date, vendor name, invoice number, invoice date, amount and sales region.
I want to make a pivot that will show me the location wise details of sales.
In addition to that I want the pivot to give the details of sales in the following buckets:
0-1000, 1001-5000, 5001-10000, 10001 and above.
These buckets will consist of total of all invoices which individually fall in the buckets.
For example if I have three five invoices with amounts as follows:
400, 800, 2000, 3000, 8000.
Then the pivot should show me the following details:
Region 0-1000 1001-5000 5001-10000 10001 and above
Amount 1200 5000 8000.