Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-09-2018, 01:36 AM
ArviLaanemets ArviLaanemets is offline How to pivot based on three fields? Windows 8 How to pivot based on three fields? Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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
Reply With Quote
 



Similar Threads
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
How to pivot based on three fields? Show calculated fields within the Pivot Table 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
How to pivot based on three fields? Pivot Table's fields janis129 Excel 7 03-02-2010 03:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft