All solutions General QuestionsPIVOT TABLE Expert Solution – General Questions on Pivot Table

Excel - General Question on Pivot Table - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hi, I needs the urgent help on how to hide the negative time value from pivot table of excel sheet
Solved by E. U. in 35 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 13/08/2018 - 09:55
are you there
Excelchat Expert 13/08/2018 - 09:56
Welcome, Thanks for choosing Got It Pro-Excel.
User 13/08/2018 - 09:57
can you help me how to hide negative time value from pivot table
Excelchat Expert 13/08/2018 - 09:57
Yeah, do you have sample data that we can work with?
Excelchat Expert 13/08/2018 - 10:01
Are you there?
Excelchat Expert 13/08/2018 - 10:04
To hide the negative values from a pivot table, use the following steps.
Excelchat Expert 13/08/2018 - 10:05
STEP 1
Excelchat Expert 13/08/2018 - 10:07
In the far right-handside of Excel we have the PivotTable Field List pane
Excelchat Expert 13/08/2018 - 10:08
Note that the pane is active when the pivotTable is selected. It can be selected by just clicking on it.
Excelchat Expert 13/08/2018 - 10:09
The PivotTable Field List Pane has four sections to its lower side: Report Filter, Column Labels, Row Labels and Values
Excelchat Expert 13/08/2018 - 10:11
In the values sections, click the on the showdown arrow of the item which is there and from the menu options which pops up, select Field Settings.
Excelchat Expert 13/08/2018 - 10:11
STEP 2
Excelchat Expert 13/08/2018 - 10:13
In the Value Field Settings dialog box, click on the Number Format
Excelchat Expert 13/08/2018 - 10:13
A Format Cells dialog box pops up.
Excelchat Expert 13/08/2018 - 10:20
STEP 3
Excelchat Expert 13/08/2018 - 10:20
Click on the Number category, then Custom option
Excelchat Expert 13/08/2018 - 10:20
Type the following in the dialog box: 0;;;
Excelchat Expert 13/08/2018 - 10:21
Then press Ok for all the dialog boxes.
Excelchat Expert 13/08/2018 - 10:25
STEP 4
Excelchat Expert 13/08/2018 - 10:27
Right click on the PivotTable, choose PivotTable options, select the Totals and Filters tab then uncheck 'Whow Grand Totals For Columns'
Excelchat Expert 13/08/2018 - 10:30
Sorry, Uncheck 'Show Grand Totals for Columns
[Uploaded an Excel file]
Excelchat Expert 13/08/2018 - 10:30
Thank you for your patience.
Excelchat Expert 13/08/2018 - 10:31
Follow the steps above correctly and the problem will be solved.
Excelchat Expert 13/08/2018 - 10:31
If this does not solve the problem, kindly let us know. Thank you.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc