row labels

Full disclosure, I'm not a pivot expert - I created this table attempting to replicate a Crystal Report, and while I've been 99% successful there's a big formatting issue - the fund numbers keep repeating when I add a new column. The columns where this issue starts are calculated fields. I'm...

I am building an exams analysis pivot table, dealing with GCSE Grades which comprise A*/A/B/C/D/E/F/G/U/X. I put the Subject Grade field in the Row Label and again in the Values to give a count of grade and all works well with all grades in the field being represented! However I want to show a...

Hello- I have created a pivot table. I use a macro button to update the pivot table. It is not picking up all of the row lables (current months). for some reason i can get it to do anything but add all the row lables (months) and hide the blank(s). ' MonthlyPivotTableUpdatePivot3 Macro '...

I have a pivot table (in tabular form) that works perfectly fine except for one little thing – every single column (except the last column immediately to the left of the numbers/values) has a box to click on to expand the data when there is no additional data to expand. It’s the little box with...

I am working with a Classic Pivot Table and have one thing that is troubling me. I have grouped my data and got things displaying however only the first record of each group is populated (displayed) Groupings/Row Labels Data Values Over Here Field1 Field2 Field3 3...

I am working with a Classic Pivot Table and have one thing that is troubling me. I have grouped my data and got things displaying however only the first record of each group is populated (displayed) Groupings/Row Labels Data Values Over Here Field1 Field2 Field3 3...

Excel Pros, I am trying to consolidate some data that I have divided into two PivotTables into just one, but I'm unsure how to go about doing it. Below is some random data for reference. What I'm trying to do is get the average of Val2 using two different criteria: 1) Avg of Val2 in groups...