LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 26th 20, 12:16 AM posted to microsoft.public.excel.programming
external usenet poster
First recorded activity by ExcelBanter: Mar 2020
Posts: 18
Default Fixed Pivot Table Row Headings

Hi Team

In an Access Crosstab Query, (which to my way of thinking is similar to a Pivot Table) you can set/fix the Column Heading values.

For instance, if I have weekly data, and not each week has data in it, it will only show those columns/row with data, but! if you go into the properties section, you can manually enter the headings so that is shows regardless of data for that week.

I cannot find anything I can do to manipulate Row or Columns in Excel, can this be done via VBA at all..??.

As I only have 2 weeks of data ( Weeks 46 & 47 of this financial year ), the PT only shows 2 rows of data for these weeks:

WeekNo_______Site1_____Site2_____Site3_____Site4__ ___Site5
_46__________01:00_____06:00_____02:00_____05:00__ ___09:00
_47__________02:00_____09:00_____06:00_____01:00__ ___02:00

Whereas I would like it to show Weeks 1 through to 52 irrespective of there being data, so it would look something like:

WeekNo_______Site1_____Site2_____Site3_____Site4__ ___Site5
__1__________00:00_____00:00_____00:00_____00:00__ ___00:00
__2__________00:00_____00:00_____00:00_____00:00__ ___00:00
__3__________01:00_____06:00_____02:00_____05:00__ ___09:00
..49__________00:00_____00:00_____00:00_____00:00_ ____00:00
..50__________01:00_____06:00_____02:00_____05:00_ ____09:00
..51__________01:00_____06:00_____02:00_____05:00_ ____09:00
..52__________00:00_____00:00_____00:00_____00:00_ ____00:00

Any thoughts or comments are appreciated.


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Headings for Sum in Pivot Table. Hemant Excel Discussion (Misc queries) 5 September 21st 09 06:14 AM
% of fixed sum in pivot table Karen Excel Discussion (Misc queries) 2 February 5th 08 12:09 AM
help! how do i create a table with fixed headings?? mercyboocoo Excel Discussion (Misc queries) 4 April 28th 06 09:32 PM
pivot table row vs column headings mrs.champ Excel Worksheet Functions 1 January 12th 05 11:35 PM
Duplicate headings in pivot table arun Excel Programming 2 July 15th 04 03:26 PM

All times are GMT +1. The time now is 02:15 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017