Results 1 to 9 of 9

How to calculate a pivot table and its bar graph in percentage instead of values?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-01-2022
    Location
    India
    MS-Off Ver
    Home 2021
    Posts
    950

    How to calculate a pivot table and its bar graph in percentage instead of values?

    Hi all,

    In the attached file, sheet "Pivot-Closed" contains a pivot as nRFT below cell E25.

    Feb month shows count as 4. Apart from the value, i also want that it should show percentage. Percentage is to be calculated by dividing cell F28 by F19 thus giving a result of 1.74%

    This should continue for subsequent months such as the count of March under nRFT should be divided by Tasks Closed in March and so on.

    Further, this percentage should be displayed in a bar graph in the sheet Graph.

    Can someone let me know how to create such a pivot?

    Many thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate a Percentage of 2 Numbers in a Pivot Table
    By bluerog in forum Excel General
    Replies: 1
    Last Post: 06-23-2021, 03:12 PM
  2. Replies: 0
    Last Post: 04-21-2021, 06:03 AM
  3. How do I calculate a percentage between fields in a pivot table?
    By plasteredric in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-18-2020, 11:06 AM
  4. [SOLVED] How to calculate percentage within pivot table
    By GIS2013 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-12-2016, 08:29 PM
  5. [SOLVED] How to calculate percentage in a pivot table (from a tally)?
    By o0o0OoO0o0O0oo00o0O0 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 07-22-2013, 11:54 AM
  6. How to calculate percentage change between values in a pivot table
    By no.18shirt in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-03-2013, 01:48 PM
  7. Replies: 2
    Last Post: 05-18-2009, 09:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1