How To Create A Second Column On Pivot Table?

[zanshin777]

How To Create A Second Column On Pivot Table?


I want to create the column from "Sheet 2 - Priority"

on the Pivot Table as second column.

How can I do that?

(Currently It appears on the first column.)

[AliGW]

Neither in this thread nor the other thread have you MANUALLY MOCKED UP what you want.

Why have you opened two threads for these issues that seem to be inter-related?

The threads have been merged - plase deal with both issues here and provide a manual mock-up of what you want the PT to look like.

[zanshin777]

Then I would have asked two different questions in a single title. Either of them would has been off-topic.

[josephteh]

1. Change Report Layout to Tabular Form
2. Remove Subtotals
3. Use Conditional Formatting to hide "(blank)" cells

[AliGW]

They are inter-related, which is why I have merged the two.

[zanshin777]

Question 1) When I chose Design - Report Layout - Tabular Form

then delete the subtotals

It looks like the image I shared;

there are minus signs on the left side of the entries?

Question 2) How to move the filter field?

Question 3) Why column names do not comes from the original column names? they look like column 1, 2, 3 on my file.

[zanshin777]

Suggestions?

[AliGW]

Attach your workbook.

[zanshin777]

Here is the file I mentioned on my last reply;

???

[JeteMc]

My guess is that the table on Sheet2 was originally produced without choosing "my table has headers".
Here is a file that shows the Activity, Priority and Duration as column headers in the pivot table.