Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-17-2019, 08:20 AM
Alaska1 Alaska1 is offline Pivot Table Windows 7 64bit Pivot Table Office 2007
Competent Performer
Pivot Table
 
Join Date: Nov 2011
Posts: 110
Alaska1 is on a distinguished road
Default Pivot Table

I have a pivot table pulling data from a table in a worksheet. I want to calculate the number of columns I have for each contact in the spreadsheet.

Example: See Attached
Julie Jones attended two events

Sum up the Yes for each contact.



Is there a way to do that in pivot table if the data is in different columns?
Attached Files
File Type: xlsx pivot.xlsx (12.6 KB, 16 views)
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Switch slicer report connections between pivot table and table tyjulianchen Excel 0 02-28-2017 04:54 AM
Pivot Table Create PIVOT chart using few rows in pivot table Santhosh_84 Excel 1 08-31-2015 06:22 AM
Pivot Table Offset Table and Pivot Table ubns Excel 1 04-17-2015 12:28 AM
Pivot Table Help asluder2000 Excel Programming 0 11-10-2014 09:28 PM
Pivot Table Question- Can the table display in the order the boxes were checked/selected? blackjack Excel 0 09-13-2014 08:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:03 AM.


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