Pivot limitations?
 

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!

Pivot limitations?
 

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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"SG" wrote in message
ps.com...
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!

Pivot limitations?
 

On May 28, 4:26 pm, "Max" wrote:
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
---"SG" wrote in message

ps.com...



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!- Hide quoted text -

- Show quoted text -

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

Pivot limitations?
 

On May 29, 9:23 am, SG wrote:
On May 28, 4:26 pm, "Max" wrote:





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
---"SG" wrote in message

ups.com...

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!- Hide quoted text -

- Show quoted text -

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 -


!!! 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

Pivot limitations?
 

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---