+ Reply to Thread
Results 1 to 2 of 2

% from target

  1. #1
    Registered User
    Join Date
    06-05-2019
    Location
    romania
    MS-Off Ver
    2016
    Posts
    47

    % from target

    I have a pivot table in which I would like to be able to calculate how much has been achieved relative to a target value.
    I would be interested in a solution without DAX or powerpivot.
    The target value would be for example 5000 for "laminate" and 1500 for "monolith".
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,117

    Re: % from target

    This proposal adds a running total column (RT) to the data range on sheet1.
    The RT column is populated using: =SUMIFS(C$2:C2,B$2:B2,B2)
    A calculated field (% of Target) is added to the pivot table using the formula: =RT/Target
    While the pivot table will operate showing both "Types" at that same time, it may be better to show on one "Type" using the filter or a slicer (modeled).
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] how to make my code work with target.column instead of target.address
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-18-2017, 09:29 AM
  2. Self Ajusting cell , moving to provide target to meet end of year target
    By andycuk7 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-15-2016, 11:22 AM
  3. Replies: 5
    Last Post: 12-16-2014, 05:47 PM
  4. [SOLVED] Worksheet_Change(ByVal Target As Range) - set to only update when 3 target cells changed?
    By trillium in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2012, 06:40 PM
  5. [SOLVED] Need alternate syntax 'Select Case' on Target.Column and Target.Row at the same time.
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2012, 11:19 AM
  6. Worksheet_CHange (ByVal Target as Range) when target is formula cell
    By coasterman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2012, 07:00 PM
  7. Replies: 1
    Last Post: 07-29-2010, 12:22 PM

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