excel prob

[dwayne]

Ive got a pivot table

Im summing all columns

When I copy the sum down row by row - it comes out with the same value every time

How do I avoid this

Ive done it before but cant remember whgich setting to change

ta

 

[Wozza]

Surely you have an assistant to help with tasks like these?!

 

[Woodchip]

I hate pivot tables! I just make my own tables.

 

[The Large One]

Ive got a pivot table

Im summing all columns

When I copy the sum down row by row - it comes out with the same value every time

How do I avoid this

Ive done it before but cant remember whgich setting to change

ta

When you copy, don't 'paste' - do a 'paste special', and it will give you a dialogue box for you to work out what you want to paste in.

 

[Clothes Peg]

I hate pivot tables! I just make my own tables.

I had never heard about pivot tables before this month, now they crop up in my vocabulary almost daily. I still don't even know what they are.

 

[Woodchip]

I had never heard about pivot tables before this month, now they crop up in my vocabulary almost daily. I still don't even know what they are.

In brief... the most wank form of consolidating data within Excel.

Well, that's my opinion anyway. I may just be using them in the wrong circumstances.

 

[Deano's Right Foot]

Manually type in the formula for the first sum (eg. =sum(c5:h5) and then copy that down.

You won't get all the getpivot and $ stuff in the formula which points is back to the original sum, rather than copying the relative positions.

*geek*

 

[Clothes Peg]

In brief... the most wank form of consolidating data within Excel.

Well, that's my opinion anyway. I may just be using them in the wrong circumstances.

I may have done them without realising it. I have Excel 2007, and it's so confusing, I never know quite what I'm doing.

 

[Deano's Right Foot]

In brief... the most wank form of consolidating data within Excel.

Well, that's my opinion anyway. I may just be using them in the wrong circumstances.

They're great if have many thousand invoice lines on Excel and you want to know how many bananas you've sold to Thailand in 2006 in SECONDS for instance, or how much in revenue your Mongolian distributor has brought in in the past 3 years.

 

[Woodchip]

They're great if have many thousand invoice lines on Excel and you want to know how many bananas you've sold to Thailand in 2006 in SECONDS for instance, or how much in revenue your Mongolian distributor has brought in in the past 3 years.

I normally just use some sort of VBA code to give me those sort of answers. *GEEK ALERT*

Possibly if I could find a good training guide for them it might help, but most of the examples only use one or two problems with simpler solutions.

 

[dwayne]

Re: Re: excel prob

When you copy, don't 'paste' - do a 'paste special', and it will give you a dialogue box for you to work out what you want to paste in.

 

[dwayne]

Manually type in the formula for the first sum (eg. =sum(c5:h5) and then copy that down.

You won't get all the getpivot and $ stuff in the formula which points is back to the original sum, rather than copying the relative positions.

*geek*

cheers...how stupidly simple was that

 

[Deano's Right Foot]

cheers...how stupidly simple was that

You're welcome - stupidly-simple is my middle name.

 

[Buzzer]

hint: if you're trying to pull data out of a very changeable pivot table you could do worse than use the match and index functions.

 

[maffew]

er, maybe I misread the question but why dont you just check the grand total for columns check box in the pivot table options?


or cant you do a calculated field within the pivot table instead?

I never write formulae outside a pivot table unless Im in a massive rush to get something done as a one off otherwise they need can updating when data is refreshed