![]() |
#2
|
|||
|
|||
![]()
You can't get cell values as Pivot Table values - they must be either Sum, Count, Average, Max, Min, Product, Numbers count, StdDev, StdDevp, Var or Varp of COLUMNS values.
As Pivot Table is 2-dimensional as max, with 3 fields you have to decide, do ROWS or COLUMNS have 2 fields to group. And as values you have to use Count - there is now way you can sum letters, and I can't see a point in summing F1 values too. You can get the result more like you want, when you add a calculated column where you concatenate values in F1 and F2 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
cannot drag fields to pivot table | jalea148 | Excel | 5 | 07-31-2017 04:03 AM |
Remove any pivot table fields with a blank entry | Ramtrap | Excel Programming | 0 | 04-14-2017 07:00 AM |
![]() |
John in DSM | Excel | 2 | 09-07-2016 02:12 PM |
Pivot table - I cant display item labels when no fields in value area | differentdrummer | Excel | 0 | 12-12-2013 05:13 PM |
![]() |
janis129 | Excel | 7 | 03-02-2010 03:16 PM |