Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table & 0
Hi all,
This is probably a simple one to answer but you never know, I have created a pivot table based on a selection of data, nothing to bad there but when the pivot table completes all I have for data are (0) and there is data there to be shown, any thoughts on why this is, I have all my titles and they look fine and I have tried alsorts! Thanks Phil |
#2
|
|||
|
|||
Hi
Are you summing the data? It might look like numbers but is actually text. Try doing a Count in the pivot table and see if that returns anything. If your 'number' are text, copy a blank, unused cell, select the range of 'numbers' and use Edit/Paste Special/Add. Hope this helps. -- Andy. "Phil" wrote in message ... Hi all, This is probably a simple one to answer but you never know, I have created a pivot table based on a selection of data, nothing to bad there but when the pivot table completes all I have for data are (0) and there is data there to be shown, any thoughts on why this is, I have all my titles and they look fine and I have tried alsorts! Thanks Phil |
#3
|
|||
|
|||
Hi Andy,
Thanks for that, I'm pulling it through from a SQL table and the formats were a little out, guess just one of those things. Thanks Again, Phil "Andy B" wrote: Hi Are you summing the data? It might look like numbers but is actually text. Try doing a Count in the pivot table and see if that returns anything. If your 'number' are text, copy a blank, unused cell, select the range of 'numbers' and use Edit/Paste Special/Add. Hope this helps. -- Andy. "Phil" wrote in message ... Hi all, This is probably a simple one to answer but you never know, I have created a pivot table based on a selection of data, nothing to bad there but when the pivot table completes all I have for data are (0) and there is data there to be shown, any thoughts on why this is, I have all my titles and they look fine and I have tried alsorts! Thanks Phil |
#4
|
|||
|
|||
Thanks for the feedback, Phil.
-- Andy. "Phil" wrote in message ... Hi Andy, Thanks for that, I'm pulling it through from a SQL table and the formats were a little out, guess just one of those things. Thanks Again, Phil "Andy B" wrote: Hi Are you summing the data? It might look like numbers but is actually text. Try doing a Count in the pivot table and see if that returns anything. If your 'number' are text, copy a blank, unused cell, select the range of 'numbers' and use Edit/Paste Special/Add. Hope this helps. -- Andy. "Phil" wrote in message ... Hi all, This is probably a simple one to answer but you never know, I have created a pivot table based on a selection of data, nothing to bad there but when the pivot table completes all I have for data are (0) and there is data there to be shown, any thoughts on why this is, I have all my titles and they look fine and I have tried alsorts! Thanks Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
pivot table | Excel Worksheet Functions | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |