Pivot table help please

B

bakercbak

New Member
Joined
Apr 24, 2014
Messages
7
My totals in my pivot table do not appear to be calculating properly if a Zero (0) is present. Is this a common problem in 2003 or am I missing something?

PSB for sample, problem area is far right highlighted ini yellow.

Any advice would be greatly appreciated.

My totals in my pivot table do not appear to be calculating properly if a Zero (0) is present. Is this a common problem in 2003 or am I missing something?

PSB for sample, problem area is far right highlighted ini yellow.

Any advice would be greatly appreciated.

TradeData
A b c d e f g h i Total Sum of %Est-6Total Sum of %Est-5Total Sum of %Est-4Total Sum of %Est-3Total Sum of %Est-2Total Sum of %Est-1Total Sum of %Est 0Total Sum of %Est+1Total Sum of %Est+2Total Sum of %Est+3Total Sum of %Est+4Total Sum of %Est+5Total Sum of %Est+6
Place of WorkEstablished RankSum of %Est-6Sum of %Est-5Sum of %Est-4Sum of %Est-3Sum of %Est-2Sum of %Est-1Sum of %Est 0Sum of %Est+1Sum of %Est+2Sum of %Est+3Sum of %Est+4Sum of %Est+5Sum of %Est+6Sum of %Est-6Sum of %Est-5Sum of %Est-4Sum of %Est-3Sum of %Est-2Sum of %Est-1Sum of %Est 0Sum of %Est+1Sum of %Est+2Sum of %Est+3Sum of %Est+4Sum of %Est+5Sum of %Est+6Sum of %Est-6Sum of %Est-5Sum of %Est-4Sum of %Est-3Sum of %Est-2Sum of %Est-1Sum of %Est 0Sum of %Est+1Sum of %Est+2Sum of %Est+3Sum of %Est+4Sum of %Est+5Sum of %Est+6Sum of %Est-6Sum of %Est-5Sum of %Est-4Sum of %Est-3Sum of %Est-2Sum of %Est-1Sum of %Est 0Sum of %Est+1Sum of %Est+2Sum of %Est+3Sum of %Est+4Sum of %Est+5Sum of %Est+6Sum of %Est-6Sum of %Est-5Sum of %Est-4Sum of %Est-3Sum of %Est-2Sum of %Est-1Sum of %Est 0Sum of %Est+1Sum of %Est+2Sum of %Est+3Sum of %Est+4Sum of %Est+5Sum of %Est+6Sum of %Est-6Sum of %Est-5Sum of %Est-4Sum of %Est-3Sum of %Est-2Sum of %Est-1Sum of %Est 0Sum of %Est+1Sum of %Est+2Sum of %Est+3Sum of %Est+4Sum of %Est+5Sum of %Est+6Sum of %Est-6Sum of %Est-5Sum of %Est-4Sum of %Est-3Sum of %Est-2Sum of %Est-1Sum of %Est 0Sum of %Est+1Sum of %Est+2Sum of %Est+3Sum of %Est+4Sum of %Est+5Sum of %Est+6Sum of %Est-6Sum of %Est-5Sum of %Est-4Sum of %Est-3Sum of %Est-2Sum of %Est-1Sum of %Est 0Sum of %Est+1Sum of %Est+2Sum of %Est+3Sum of %Est+4Sum of %Est+5Sum of %Est+6Sum of %Est-6Sum of %Est-5Sum of %Est-4Sum of %Est-3Sum of %Est-2Sum of %Est-1Sum of %Est 0Sum of %Est+1Sum of %Est+2Sum of %Est+3Sum of %Est+4Sum of %Est+5Sum of %Est+6
1a100%100%100%100%100%100%100%100%100%100%100%100%67%100%100%100%100%100%100%100%100%100%100%100%100%67%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%100%100%100%100%100%100%100%100%100%100%100%100%100%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%100%100%100%100%100%100%100%100%100%100%100%100%71%
b111%111%111%111%111%111%111%111%111%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%86%86%86%86%86%86%86%86%71%71%71%71%71%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%100%100%100%100%100%100%100%100%96%92%92%92%92%
c100%100%100%100%100%100%100%100%100%100%100%100%100%81%81%81%81%81%81%76%76%76%71%71%71%71%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%100%100%100%100%100%90%90%90%90%90%90%90%90%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%91%91%91%91%91%89%87%87%87%85%85%85%85%
d105%105%105%105%105%105%105%105%100%100%100%100%100%133%133%133%133%133%129%125%117%113%108%108%104%104%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%100%100%100%100%92%92%92%92%100%100%100%100%100%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%115%115%115%115%114%112%110%107%105%103%103%102%102%
e0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%87%87%87%87%87%78%74%65%74%74%74%74%74%0%0%0%0%0%0%0%0%0%0%0%0%0%87%87%87%87%87%78%74%65%74%74%74%74%74%
1 Total 104%104%104%104%104%104%104%104%102%100%100%100%98%107%107%107%107%107%105%102%98%96%93%93%91%89%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%97%97%97%97%94%90%90%90%90%90%90%90%90%87%87%87%87%87%78%74%65%74%74%74%74%74%0%0%0%0%0%0%0%0%0%0%0%0%0%101%101%101%101%101%98%96%94%94%92%92%91%90%
2a100%100%100%100%100%100%100%100%100%100%100%100%100%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%100%100%100%100%100%100%100%100%100%100%100%100%100%
b100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%100%100%100%100%100%100%100%100%100%100%100%100%100%
c100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%100%100%100%100%100%100%100%100%100%100%100%100%100%
d100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%100%100%100%100%100%100%100%100%100%100%100%100%100%
e0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%
2 Total 100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%100%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%
3a0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%100%100%100%100%100%0%100%100%100%100%100%100%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%100%100%100%100%100%0%100%100%100%100%100%100%
b100%100%100%100%100%100%100%100%100%100%100%75%75%100%100%100%100%100%100%100%100%100%100%100%100%100%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%100%100%100%100%100%100%100%100%100%100%100%100%100%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%100%100%100%100%100%100%100%100%100%100%100%91%91%
c100%100%100%100%100%100%100%100%100%100%100%100%100%60%60%60%60%80%60%60%60%60%60%60%60%60%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%100%100%100%100%100%100%100%100%100%100%100%100%100%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%87%87%87%87%93%87%87%87%87%87%87%87%87%
d0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%
e0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%
3 Total 100%100%100%100%100%100%100%100%100%100%100%90%90%80%80%80%80%90%80%80%80%80%80%80%80%80%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%86%100%100%100%100%100%86%100%100%100%100%100%100%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%

<COLGROUP><COL style="WIDTH: 48pt" span=132 width=64><TBODY>
</TBODY>
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
You must log in or register to reply here.

Similar threads

G
  • Question
Weighted scores with some weightings the full 100%
Replies
7
Views
94
etaf
etaf
E
  • Solved
Get a 2D spilled formula to fulfill a distribution table matching the ranges of both dimensions
Replies
3
Views
79
Fluff
Fluff
A
  • Solved
Problem with multiple IFS, IF and AND in long formula
Replies
2
Views
167
arendberg
A
A
  • Solved
Extracting Data from a table
Replies
5
Views
237
JamesCanale
JamesCanale
P
  • Question
Turning OFF the visibility of a horizontal (category) axis labels if certain conditions apply
Replies
1
Views
423
NdNoviceHlp
NdNoviceHlp

Forum statistics

Threads
1,215,362
Messages
6,124,502
Members
449,166
Latest member
hokjock

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top