Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-08-2018, 11:50 AM
Jamal NUMAN Jamal NUMAN is offline How to pivot based on three fields? Windows 7 64bit How to pivot based on three fields? Office 2010 64bit
Expert
How to pivot based on three fields?
 
Join Date: Nov 2010
Posts: 615
Jamal NUMAN is on a distinguished road
Question How to pivot based on three fields?

How to pivot based on three fields?



For example, in the screenshots below, I wanted to pivot based on the following fields

To have F1 as rows
To have F2 as columns
To have F4 as values

Currently, it appears that excel has no power to write the values of F4 in the pivot table.

How this can be performed?


Thank you

Jamal
Attached Images
File Type: jpg Clip_187.jpg (104.5 KB, 24 views)
File Type: jpg Clip_188.jpg (163.9 KB, 24 views)
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 05:31 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