Results 1 to 3 of 3

Using Calculated Items to calculate percentage of total

Threaded View

  1. #1
    Registered User
    Join Date
    03-08-2023
    Location
    Belgium
    MS-Off Ver
    Excel 365
    Posts
    2

    Using Calculated Items to calculate percentage of total

    Dear all,

    I want to create a summary table using pivots to check if items are on time or not on time. Items are delivered on a certain date and a separate column indicates that it was on time or not on time. My pivot groups by quarter and month in rows which is what I want and summarizes the columns how many are on time, not on time and the sum of both.
    What I want to do is to calculate percentage on time (On Time/Grand Total) for charting purposes. I'm experienced with Excel and pivot tables, but calculated fields are new to me. This kind of calculation seams very common, but I'm lost for a (simple) solution. Is this even possible, with or without calculated fields?
    I have attached an example with randomized data.

    Any help would be greatly appreciated.

    Kr.
    Attached Files Attached Files
    Last edited by Excellobizzaro; 03-13-2023 at 09:17 AM. Reason: Moved to Solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 05-09-2022, 03:26 PM
  2. Replies: 3
    Last Post: 10-22-2020, 08:10 PM
  3. Calculate percentage of open items
    By geliedee in forum Excel General
    Replies: 3
    Last Post: 06-25-2019, 02:36 AM
  4. Calculate Total Pay Using Pivot Table Calculated Fields or VBA Macro
    By Kimston in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-25-2018, 02:41 AM
  5. [SOLVED] Pivot table calculated item doesn't calculate on Grand Total
    By nfcascalheira in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-27-2014, 08:10 AM
  6. [SOLVED] Grand Total of Calculated Items in a Pivot Table Incorrect
    By drstrings in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-11-2013, 11:57 AM
  7. Replies: 1
    Last Post: 07-09-2009, 08:22 PM

Tags for this Thread

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