On my pivot table I have a range of values that I am using in my Row Labels section of my pivot table. These values are in the 1k increments. I would like to condense the information so that those increments are in 10k groupings. I have another table where this was done and I assume it is a custom filet but I am unsure how to create that filter. In the pdf snap shot I am looking at the column on the far left.
example.xlsx
Last edited by rhuark; 01-27-2012 at 08:55 AM.
I just right click your Row label column, picked Group, it seems you already have 10,000 then I hit Ok, and the table showed groups of 10,000.
Was that what you meant?
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
That is exactly what I need but I dont see that when I click on the header label on row 3. I get "copy, format, refreh, Pivot table options and Hide field list".
Could you do this step by step for me? I really appreciate it.
Right click on one of the values in the column instead of the header.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
That is awesome
thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks