+ Reply to Thread
Results 1 to 2 of 2

Switching Between two sets of units

  1. #1
    Forum Contributor
    Join Date
    05-29-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    143

    Switching Between two sets of units

    Hello Excel Gurus,

    I'm working on a difficult problem that I believe will require a macros, but I'm not sure. I'm creating a dashboard using powerpivot and I have two sets of data that I would like to toggle between, Raw Data (15 columns) and Scores Based off of Raw Data (10 columns). I would like to add it so that I can just toggle between the two using a slicer, but other than adding all the columns to a hierarchy, which would look pretty sloppy, I'm not sure how to do this.

    Does anyone have any tips for me?

  2. #2
    Forum Contributor
    Join Date
    05-29-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    143

    Re: Switching Between two sets of units

    Ok, i feel like I'm in the wrong place, but I don't see a powerpivot section and I figure the level of help I need would be from people int his category... I'll gladly post elsewhere. Also, I think I figured out a very horrible alternative way of doing this that I'm sure will create problems down the road for me, but I have doubled the data (I had 1000 rows of data and now I have 2000) and deleted the raw data from the first half and deleted the Calcualted Scores from the second half and created another column that says whether the data is Raw data or Calculated data. This has allowed me to create a slicer to toggle between the two different data sets... I know this is a really bad way of doing this, but it's the only thing I have come up with.

+ 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] Calculate the Bonus units according to the quantity of the units bought (Help)
    By mo_naf in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-15-2012, 05:51 PM
  2. [SOLVED] Excel 2007 : Switching Data Sets using a Check Box
    By HangMan in forum Excel General
    Replies: 12
    Last Post: 07-12-2012, 12:20 PM
  3. Switching Ink On or Off
    By ACM2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2010, 05:16 PM
  4. switching last name/first name
    By charlie11k in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-31-2009, 11:13 AM
  5. Need to Insert down between sets then border sets
    By iturnrocks in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-10-2008, 04:10 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