pivot tables shows grand totals sometimes, sometimes not...?

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

any clues as to why i get grand totals, and sometimes i dont.

occassionally i go over my numbers and fix errors and suddenly the
grand total appears.

but sometimes i dont find any errors and it still doesnt appear.


any clues?
 
It sounds like your *numbers* are actually text representations of numbers.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
sure nough, i went back over my data and an error was in there
somewhere ( i had hidden it using conditional format).
when i went back, i deleted it and my totals popped right up!

thanx a million!
 
Glad that you found it. Thanks for the feedback.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top