K
kannan
I have data in a spreadsheet that i want to aggregate, using pivot tables.
Each row has the following data
Customer
License
Product
Each row contains customer information, license and product information.
I want to be able to create a pivot table that computes a count of customer
with a combination of products
Here is an example:
Customer License Product
C1 L1 P1
C1 L2 P2
C2 L1 P1
What I want in my pivot table is to show the customer that have P1 AND P2,
as follows
Customer: C1
Count: 1
I do not want C2 to be included in the pivot table.
How do I achieve this?
Thanks.
Kannan
Each row has the following data
Customer
License
Product
Each row contains customer information, license and product information.
I want to be able to create a pivot table that computes a count of customer
with a combination of products
Here is an example:
Customer License Product
C1 L1 P1
C1 L2 P2
C2 L1 P1
What I want in my pivot table is to show the customer that have P1 AND P2,
as follows
Customer: C1
Count: 1
I do not want C2 to be included in the pivot table.
How do I achieve this?
Thanks.
Kannan