Pivot - show as % of sub-total

  • Thread starter Thread starter Me!
  • Start date Start date
M

Me!

Hi,

Is it possible to do the following in a pivot table (the data refers to
cars)?

I have two row fields, 'Manufacturer' and 'Model', with the data values
being a count of model.

So, for example there are five different Audi models, each with a count. I
want to show the model count as a % of the Audi sub-total (not as a % of the
overall total).

This would give each model's total as a % of its respective manufacturers
total.

Is this possible?

Many thanks.
 
Hi,

Is it possible to do the following in a pivot table (the data refers to
cars)?

I have two row fields, 'Manufacturer' and 'Model', with the data values
being a count of model.

So, for example there are five different Audi models, each with a count.  I
want to show the model count as a % of the Audi sub-total (not as a % of the
overall total).

This would give each model's total as a % of its respective manufacturers
total.

Is this possible?

Many thanks.
Click to expand...

Hi,
maybe the use of a helper columns helps.
HTH, cheers Michael
 
Michael.Tarnowski said:
Hi,
maybe the use of a helper columns helps.
HTH, cheers Michael
Click to expand...

Hi,

I'd thought of having an additional column in my source data, but it
would have to include some form of aggregation, which I'd rather do in
the pivot, i.e. I could have a column in my source data which gives the
manufacturer count for each model, and then in the pivot show my model
count as a % of the Manufacturer count.

But there would be a lot of repeated data, i.e. the manufacturer total
for each model would be the same, which is rather inefficient.

SO, are you saying it can't be done in the pivot?

Cheers....Jay
 
Hi Herbert,

The link won't open. Can you advise how it's done?

Thanks......Jason
 
You must log in or register to reply here.

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

Pivot table calculated field Count(field) / sum(field) 0
Excel VBA - counting cells by colors and names to it in two different rows. 0
Pivot table Options 4
Pivot Table 1
Count Unique Items with Multiple Criteria 12
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table Grand Total Issue 3

Back
Top