Re: Pivot Table & 0

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for the feedback, Phil.

--
Andy.


"Phil" <Phil@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C9D54106-CA38-4AB9-BC16-0E06A2C79A83@xxxxxxxxxxxxxxxx
> 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" <Phil@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:E190BDC1-077C-4791-AA95-4E42213C6D1A@xxxxxxxxxxxxxxxx
>> > 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
>>
>>
>>


.

Relevant Pages

  • Re: Pivot Table & 0
    ... I'm pulling it through from a SQL table and the formats ... Thanks Again, Phil ... "Andy B" wrote: ... > Try doing a Count in the pivot table and see if that returns anything. ...
    (microsoft.public.excel.misc)
  • Re: SUMIF
    ... I would suggest using a Pivot Table for this. ... The option is under Data/Pivot Table and Chart. ... Andy. ... > and the adjacent column with total sales by group irrespective of date. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Pivot Tabel - Group
    ... Or, add a new column in the source data table, and use a ... Refresh the pivot table, ... andy wrote: ... Excel FAQ, Tips & Book List ...
    (microsoft.public.excel.newusers)
  • Re: Count and display number of items
    ... You could add the names to you pivot source and use them instead of the ... Peo Sjoblom "Andy" wrote in message ... > "Earl Kiosterud" wrote in message ...
    (microsoft.public.excel)
  • Re: Pivot Tables
    ... this forum never fails to come up with an ... >Andy. ... >> I nned some Pivot table advice (a website address for ...
    (microsoft.public.excel.newusers)