fixed columns in a pivot table

		Microsoft Office Forums > Microsoft Excel > Excel
fixed columns in a pivot table

FAQ

Thread Tools

Display Modes

06-28-2016, 02:07 PM

dbsoccer51 dbsoccer51 is offline

Windows 7 64bit fixed columns in a pivot table

Office 2013

Novice

Join Date: Dec 2015

Posts: 3

Figured it out. Check on the "Show items with no data" option in the field settings for columns. Easy. I need to create three "dummy" rows without dates to seed the column headings but it seems to work fine.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create PIVOT chart using few rows in pivot table	Santhosh_84	Excel	1	08-31-2015 06:22 AM
Fixed Stationary Columns (Word 2010)	ptristan88	Word	5	07-02-2014 07:28 PM
Can you add percentage (%) columns to a pivot table?	New Daddy	Excel	2	11-23-2013 09:49 PM
Fixed duration, fixed units, fixed work, effort driven. How, why and when use it all	Evgeny	Project	3	01-03-2013 06:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:37 PM.