QUESTION: How can I conditionally compute data in a pivot tables?

  • Thread starter Thread starter kannan
  • Start date Start date
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
 
Back
Top