Pivot limitations?

S

SG

Hi There,

I am trying to make a PT with a source of 25.000 lines on 17 Fields,
among which one field is called "UNITS"and another "Country"

I just try to sum the number of Units by Country but it just shows me
0 everywhere.
On a smaller "sample" (eg. 1000 lines) I get a result ...

Any ideas what's wrong and how to solve this?

Thanks in advance!
 
M

Max

Probably some numbers in UNITS are text numbers
Try this to coerce all to real numbers.
Copy an empty cell
Select the entire UNITS col, right-click > paste special > check "Add" > OK
Then just right-click within the pivot > Refresh Data
 
S

SG

Probably some numbers in UNITS are text numbers
Try this to coerce all to real numbers.
Copy an empty cell
Select the entire UNITS col, right-click > paste special > check "Add" > OK
Then just right-click within the pivot > Refresh Data
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik









- Show quoted text -
Click to expand...

HI Max,

I've been thinking about that but that's not the cause ...
I try to create a PT via MSquery ... somehow my SQL statement returns
all '0'-s in my data!
And I've no idea why?!

I tried this technique already before and it works ...I'll make a new
post about it, as it is more MSQuery related than PT-related.
SG
 
S

SG

HI Max,

I've been thinking about that but that's not the cause ...
I try to create a PT via MSquery ... somehow my SQL statement returns
all '0'-s in my data!
And I've no idea why?!

I tried this technique already before and it works ...I'll make a new
post about it, as it is more MSQuery related than PT-related.
SG- Hide quoted text -

- Show quoted text -
Click to expand...


!!! Well, the technique (to create PT via MSquery) is OK

( although I understand that it prefers Global Names over Local ones,
or maybe I need my SQL statement then with Sheet1!ACTUALS instead of
ACTUALS? ...)
SELECT *
FROM ACTUALS ACTUALS
UNION ALL
SELECT *
FROM LY LY

BUT the data need to be in the right FORMAT for MSQuery anyhow.
Multiplying my data with "1" turned it into numbers ...
!!!

SG
 
M

Max

Multiplying my data with "1" turned it into numbers ... !!!

Yes, that's an alternative to coerce it into real numbers.
Trust you got it sorted out, then.
 
Top