Pivot Table - Edit displayed values

I have a pivot table that summarises data from a timesheet. The summary looks something like the following and shows the number of 15 minutes intervals spent on a range of categories and jobs:

PivotTableSample.PNG

How can I have this pivot table display the number of minutes instead of the number of intervals (i.e. it needs to take the value displayed currently and multiple it by 15). I'm sure there must be some simple way to achieve this but can't figure it out (I don't want to use vba).

Thanks.

Hi,

This is possible if you use 'Fields, Items & Sets' option under the 'Options' tab.

1. Keep the Cursor in one of the cells in the Pivot Table
2. Select Options on the Menu tab
3. Select 'Field Sets & Items'
4. Use 'Calculated Field' option
5. You can insert a new field which is a multiplier of your existing field.

I have uploaded a sample excel sheet here.

Regards,
Chandra


Please do not forget to click on the '* Add Reputation' button if I was helpful in resolving the issue.

Hello Chandra,

Thank you for your advise and example however I can't get this working on my pivot table. I have attached a simplified version of this below - are you able to give me some further advice?

Timesheet_with_pivot_table.xlsx

Thank you very much.

Hi,

Sorry for the late response.

I have created a new template by looking at your excel sheet. Please see if this would work for you (template attached).

Regards,
Chandra

Hello Chandra,

Originally Posted by cbatrody

Hi,

Sorry for the late response.

No Worries! Very much appreciate your help! This looks perfect - I'll give this a try and if I have any further problems I'll post back here. Thank you.