Pivot Table - just certain subtotals

[sabsx]

Hi!

I can't find a way to display just subtotals which are > 500k... can anyone give me a hint?

regards,

sabsx

 

[Fazza]

SQL was not developed by Microsoft. It is an international standard for working with databases. It is not a relational database.

 

[Fazza]

OK. Change the "20080318_4" argument to a cell in a record. That way a different result will be returned for each line. (Now it is always the same.)

 

[sabsx]

already tried this... then I get #value... but sometimes it works... and most of the times I get # value even though there is a number in the quote number cell

 

[Stormseed]

SQL was not developed by Microsoft. It is an international standard for working with databases. It is not a relational database.

ok sorry, I referred to Microsoft SQL Server. Ofcourse the SQL (Structured Query Language) is universal. Moreover, MS-SQL Server was adapted from Sybase.

Good lord...have to be so specific wen explaining things on thsi board

 

[Fazza]

Then you haven't done exactly the right thing. Simply changing from the hard coded text value to a cell containing that value should not give an error.

Is that the correct field? Is it the field against which you want to check subtotals?

I think you must be close to the right answer. Suggest you keep trying and post an image if you're stuck.

 

[sabsx]

hm... can't say why it works now... just clicked refresh data...

 

[Fazza]

ok sorry, I referred to Microsoft SQL Server. Ofcourse the SQL (Structured Query Language) is universal. Moreover, MS-SQL Server was adapted from Sybase.

Good lord...have to be so specific wen explaining things on thsi board

Who was it? Something like, I might be a pedant but I like to get the facts right.

It is worth making the distinction 'cause the original post was confusing to those who really don't know about this stuff and are trying to learn.

 

[Fazza]

hm... can't say why it works now... just clicked refresh data...

So, all OK now?

Remember, you'll need to do 2 refreshes to get the right answer in the final PT as it depends on the GETPIVOTDATA results from the helper PT.

 

[Stormseed]

Who was it? Something like, I might be a pedant but I like to get the facts right.

who was what ?

btw, even I am trying to learn

 

[sabsx]

my results look good to me now... I added macros for the refreshs... everything seems to work... thanks a million for your help!!!