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.
