Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-17-2019, 08:20 AM
Alaska1 Alaska1 is offline Pivot Table Windows 7 64bit Pivot Table Office 2007
Advanced Beginner
Pivot Table
 
Join Date: Nov 2011
Posts: 96
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, 14 views)
Reply With Quote
Reply



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 03:34 AM.


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