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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unique items in a Pivot table 1
Pivot Table Formula Problem 1
Pivot table - Problem with % 5
Pivot Table - Repeat row data 1
How to sort data in data area in a pivot table 2
Rearranging DATA 6
Calculating fields in pivot tables 2
Pivot Table - hide if no data 2

Top