LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
RoryMacLeod
 
Posts: n/a
Default Custom formula to show each item as percentage of grand total?

Have a PT like this:

Month Who
Jan 3.5
Feb 2.2
Mar 3.3
Total 9.0

I want to add a new custom field or whatever on the right of this that will
show each item as a percentage of the total so I see 2.2 and 25% next to it.

Thanks
Rory


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to calculate a percentage formula with existing data? MeaganNW Excel Worksheet Functions 4 September 8th 08 08:39 AM
I want the results of a formula to show in cell, NOT THE FORMULA! ocbecky Excel Discussion (Misc queries) 4 December 10th 04 08:39 PM
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? Arvi Laanemets Excel Discussion (Misc queries) 0 December 2nd 04 11:29 AM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM
Why does the formula result show a number but the screen shows ze. Jam-Du Excel Worksheet Functions 2 November 12th 04 09:07 PM


All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"