X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Pivot Table Help, Any Version    
post Nov 15 2017, 11:10 AM

Posts: 319
Joined: 13-February 03

Racking my brains here.

All I want is for the sum of these figures (£) to be given at the bottom of the Column. Like it is for the Quantity column.

Now when I add Sum to the field it gives me what you can see in image 2.

The value should give me £935.93 (i.e sum of all) but instead im getting this?

My source data does have blanks but I have the table filtering those out.

Any help greatly appreciated if you can point me in the right direction.
Attached File(s)
Attached File  1.png ( 2.1K )Number of downloads: 0
Attached File  2.png ( 2.88K )Number of downloads: 0
Go to the top of the page
post Nov 15 2017, 11:21 AM

Posts: 2,264
Joined: 27-February 09

Sounds like you don't want a pivot table at all. Just a sum at the bottom of each of the two columns. Either that or you're leaving a lot out.

Do you have some sample data you could share? (It can be fake, just representative... and please explain the result you're looking for)
Go to the top of the page
post Nov 15 2017, 11:30 AM

Posts: 319
Joined: 13-February 03

Sorry I've cropped some data out as its sensitive.

My data comes from another sheet. Sometimes it may be 12 rows of info like in this instance, sometimes it will be more and sometimes it will be less.

I can try to attach an example file if that will help.
Attached File(s)
Attached File  1.png ( 10.01K )Number of downloads: 1
Go to the top of the page
post Nov 17 2017, 05:18 PM

Utter Access VIP
Posts: 6,017
Joined: 22-June 04
From: North Carolina

I'm with MadPiet on this issue. There may be a few pivot table questions that can be answered by looking at pictures, however most require knowledge about how the source data are organized. A sample workbook with non-sensitive data would go a long way to helping us help you. You really can't talk intelligently about pivot tables without also looking at the source data.


One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
Please zip and attach samples. It makes life easier for those who have to figure out what you are trying to do. Thanks
Go to the top of the page
post Nov 20 2017, 03:21 PM

Posts: 1,064
Joined: 8-February 02
From: California, USA

Hi Bazza,

I think there's some fundamentals of pivot tables that you need to review. You're using the Fee column as the data you're performing some type of evaluation (or display) against. So, in your pivot, FEE is unique. You can count how many times that specific FEE occurs in your data. You can do a SUM of some column, such as Quantity against each unique fee value.
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    15th December 2017 - 03:05 AM