+ Reply to Thread
Results 1 to 2 of 2

Set a goal that moves with pivot table slicers

  1. #1
    Registered User
    Join Date
    07-23-2013
    Location
    New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    2

    Set a goal that moves with pivot table slicers

    Hi,

    I want to create pivot tables and a dashboard that displays a monthly goal, and which adjusts according to slicers set (month and year).

    I have a 'Main data' tab which I records entries weekly.

    I have a "Pivot tables' tab that analyses how tasks are progressing over the month.

    What I want to be able to do, is set a monthly goal next to the pivot table data, and have values in my dashboard move with the slicers. I want 3 values that move with the slicers:

    1) tasks out this month
    2) monthly goal (manually set next to the pivot table tab data)
    3) a countdown that show have far off the goal I am

    I have set up a mock spreadsheet to demonstrate what I am after (as best I can).

    I am working off Excel 2010.

    Any help would be greatly appreciated!
    Attached Files Attached Files

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

    Re: Set a goal that moves with pivot table slicers

    The way the question is worded it sounds as if you will only select one month at a time so it would seem that all of the information needed will be in row 3 of the Pivot tables sheet.
    1. You only need one set of slicers as both sets of slicers currently used are connected to the pivot table on the Pivot tables sheet
    2. Paste the following into cell D3 (Pivot table sheet): =C3-B3
    3. Select Textbox3 (Dashboard sheet) and paste the following into the formula bar: ='Pivot tables'!B3
    4. Select Textbox4 (Dashboard sheet) and paste the following into the formula bar: ='Pivot tables'!C3
    5. Select Textbox5 (Dashboard sheet) and paste the following into the formula bar: ='Pivot tables'!D3
    Let us know if you have any questions.
    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] Pivot Table & Slicers
    By Statz in forum Excel General
    Replies: 3
    Last Post: 10-09-2017, 09:35 PM
  2. Slicers for Pivot Table
    By Balzer13 in forum Excel General
    Replies: 1
    Last Post: 08-03-2017, 10:36 AM
  3. [SOLVED] Is there any way to tell if a pivot table has slicers?
    By ChemistB in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-07-2016, 12:56 PM
  4. Pivot Table Formatting - Slicers
    By aaaaaron42 in forum Excel General
    Replies: 0
    Last Post: 10-05-2015, 12:59 PM
  5. [SOLVED] Disconnect Slicers, Change Pivot Table Source, Reconnect Slicers: a problem
    By Geoff. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 02:27 PM
  6. Can you have pivot table fields as slicers?
    By no.18shirt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2013, 05:12 PM
  7. Replies: 2
    Last Post: 05-24-2013, 03:58 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