How do i show repeated values (Pivot table)

**ThomasCarter** · 10-26-2012, 10:06 AM

I have a pivot table that has a list of people that have a list of figures associated with them in different groups.

Person 1 has 0.5 in Group 1 and 0.5 in Group 2.

The pivot table shows this as 0.5 in Group 1 and then it does not show any value for Group 2, with an assumed "Same as above"... This is bad as i want to calculate totals with this data and need repetitive values to show so the formula can see them.

Apologies if I am not being clear enough, incapable of attaching an example at the moment, will attach one tomorrow when I am able.

**jeffreybrown** · 10-26-2012, 10:08 AM

Hi ThomasCarter,

I think I understand and you can't do this in a pivot table unless you upgrade to 2010.

**JosephP** · 10-26-2012, 10:29 AM

it sounds as though you are trying to total fields that are row fields and not data fields? may we ask why?

**ThomasCarter** · 10-26-2012, 11:36 AM

I am not very experienced with pivot tables but i have come to an amature solution...

I made the thing i wanted to be calculated into a data field and then used a formula to sum the result as the data field showed all the numbers...

Problem is the data feild looks odd (It goes around the table) i want it to just look like every other field.

Ie

A4 = Name B4 = Number C4 = Group D4 = Number i wish to be calculated E4 = Team

But now it's A4 = Name B4 = Number C4 = Group A3 = Number i wish to be calculated D4 = Team

And is confusing and ugly to users.

Hopefully there is a 2003 workaround...

Edit: While i have your attention, easy question: Is it possible to make a field that is not at the beginning the thing that is what defines the order of the data. To use the above data as an example, we have names them numbers. If i wanted the data to be sorted numerically instead of alphabetically, how would i do that? Thanks.

**JosephP** · 10-29-2012, 12:40 PM

you should be able to sort the name field by the data field using the field settings if that's what you mean?

**ThomasCarter** · 11-07-2012, 12:02 PM

Yeah i have the option to do that, but it seems to prioritise the number in row A (It's set to manual, there was no "Do not sort" option)

So regardless of what I sort the names by, it will always be sorted by numbers first.

**JosephP** · 11-07-2012, 12:21 PM

yes it will only sort within the groupings so to have the whole table sorted by name, the name field has to be the first row field

**ThomasCarter** · 11-08-2012, 04:50 AM

Ahh that's a shame.

Any workarounds? I considered having 2 name fields, putting the first one in the first row and hiding it. But of course you can't have 2 of the same field! Ahh! Now I'm considering creating a helper column that takes the data from the names and using that as the "2nd names", but if you can offer a less complicated option I'm all ears!

Sadly simply making names first isn't an option.

**JosephP** · 11-08-2012, 04:56 AM

no other workarounds-it makes no sense to sort the second row field with priority over the first since then the first field couldn't be grouped properly

I'm having a hard time picturing why you'd want to do that?

**ThomasCarter** · 11-08-2012, 08:51 AM

As am I. I am helping a colleauge and she insists that it is sorted alphabetically but she wants the ID number first.

I assume she wants to look through the list for a name rather than an ID number, but this does not answer why she finds it important to have the ID number first.

Anyway, despite being mildly time consuming to put in place, my workaround seems to work fine. Thread solved. Thanks for all your help.

**JosephP** · 11-08-2012, 09:27 AM

my pleasure. can't she just use the filters?

How do i show repeated values (Pivot table)

LinkBack

Thread Tools

Rate This Thread

Display

How do i show repeated values (Pivot table)

Re: How do i show repeated values (Pivot table)

Re: How do i show repeated values (Pivot table)

Re: How do i show repeated values (Pivot table)

Re: How do i show repeated values (Pivot table)

Re: How do i show repeated values (Pivot table)

Re: How do i show repeated values (Pivot table)

Re: How do i show repeated values (Pivot table)

Re: How do i show repeated values (Pivot table)

Re: How do i show repeated values (Pivot table)

Re: How do i show repeated values (Pivot table)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions