Pivot Table - how do I add a column?

  • Thread starter Thread starter ajnmx
  • Start date Start date
A

ajnmx

I have a data table with a column of data called "durations" with value
from 1 to 14, but some are missing (there's no 6 or 13). On my pivot
table I want the column headings to be the numbers 1 to 14 without the
missing figures. I know I could add these as dummies to the data
table, but can I somehow force them to appear on the pivot table
directly?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table 1
PivotTable Sum 2 Columns 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table Summary Error? 6
Pivot Tables by Macro 2
Pre-configuring Pivot table "views" 4
Pivot Table static columns 4
Pivot tables - new columns 5

Back
Top