K
Kruti
Hi, this may be a stupid question, but I can't figure it out! I have data in
the following format:
Product Price Quantity Revenue
Client 1 X 1 2 2
Client 1 Y 5 7 35
Client 1 X 1 10 10
Client 2 X 1 3 3
I would like to create a pivot table that shows both the total quantity and
revenue by client by product. I can easily make the table for either
quantity or revenue, but am not sure how to show the sums for two data fields
at the same time.
Example:
Quantity Revenue
Client 1
Product X 12 12
Product Y 7 35
Client 2 3 3
Can you tell me how to do this? Thanks!
the following format:
Product Price Quantity Revenue
Client 1 X 1 2 2
Client 1 Y 5 7 35
Client 1 X 1 10 10
Client 2 X 1 3 3
I would like to create a pivot table that shows both the total quantity and
revenue by client by product. I can easily make the table for either
quantity or revenue, but am not sure how to show the sums for two data fields
at the same time.
Example:
Quantity Revenue
Client 1
Product X 12 12
Product Y 7 35
Client 2 3 3
Can you tell me how to do this? Thanks!