+ Reply to Thread
Results 1 to 3 of 3

how to subtract target by Task 'A' in using calculated field in pivot table

  1. #1
    Registered User
    Join Date
    08-30-2009
    Location
    melbourne
    MS-Off Ver
    Excel 2013
    Posts
    26

    how to subtract target by Task 'A' in using calculated field in pivot table

    Hi,

    I have a created a pivot table showing count of Doc Number by month in relation to Task type.
    Also, i have added a targeting number (3) using calculated field.

    By doing so, I would like to get a target vs. actual comparison graph.


    Question 1. I was trying to get number after subtracting Target by how many Task 'A' completed by month using calculated field. However, I could not work out to get the right number. Is there any way to do it?

    Question 2. If the target increases from Feb 2020, is there anyway to reflect in excel without affecting previous months?

    Please advise me. Thank you in advance.

    Regards,
    MK
    Attached Files Attached Files

  2. #2
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    9,217

    Re: how to subtract target by Task 'A' in using calculated field in pivot table

    Administrative note

    Still using XL2003 as indicated in your profile?
    If not,perhaps update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to? Members tailor answers based on your Excel version.
    Thanks
    You really don't have to give me rep points for moderating. It's part of the job. Keep rep points for those who find solutions

  3. #3
    Registered User
    Join Date
    08-30-2009
    Location
    melbourne
    MS-Off Ver
    Excel 2013
    Posts
    26

    Re: how to subtract target by Task 'A' in using calculated field in pivot table

    Hi,

    I should have corrected before, corrected now.
    Thanks
    MK

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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