Results 1 to 6 of 6

Slicer that will select a column

Threaded View

  1. #1
    Registered User
    Join Date
    01-16-2014
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    11

    Slicer that will select a column

    I am pretty new to pivot tables and am struggling. I have a massive spreadsheet with assessment percentages in for 29 different subjects going across the columns. What can do is slice, by say gender, but i also want to slice by subject as well so that my tables will pre-populate

    I don't want to have to create multiple copies of the "Art" sheet and then keep changing the subject

    What am i missing?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Catastrophic Error with Slicer To Select x Days
    By Tellm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2015, 05:56 AM
  2. Have a cell equal to the value I select in a slicer?
    By qlikview in forum Excel General
    Replies: 1
    Last Post: 07-07-2015, 02:56 AM
  3. VBA code to create input box that will select one value in a slicer
    By Ind711 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2015, 04:19 PM
  4. Newbie: Auto Select/un-Select an Range of Slicer Items
    By luckyali in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2014, 09:52 AM
  5. Select fields in slicer with macro
    By joelvankesteren in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-13-2014, 02:21 AM
  6. How to auto select from a Slicer last or top item
    By xtrenge in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-07-2014, 06:22 PM
  7. 'select all' option in slicer
    By Paul-NYS in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-24-2012, 09:23 AM

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