+ Reply to Thread
Results 1 to 1 of 1

Pivot Table That Only Shows the Monthly Split for the First Value Data but not the Second

  1. #1
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    Excel 2021
    Posts
    1,022

    Pivot Table That Only Shows the Monthly Split for the First Value Data but not the Second

    Morning all,

    I've got a pivot table that contains two types of value data. I'd like to create a pivot table that shows the monthly split for the first value data but only shows the grand total for the second value data. Is this possible? As a quick and easy solution I just hid the relevant columns (N to Y) but I'm intrigued to know whether it is actually possible?

    The attached example hopefully explains a bit more clearly what I'm looking to achieve.

    Cheers,

    Snook
    Attached Files Attached Files

+ 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. SQL Pivot table shows percentages as date and time
    By mhf89 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-19-2015, 09:09 PM
  2. Replies: 0
    Last Post: 10-09-2013, 04:54 AM
  3. Replies: 4
    Last Post: 03-27-2013, 05:56 PM
  4. Excel 2007 : Pivot table with columns of monthly data
    By skibumtx in forum Excel General
    Replies: 2
    Last Post: 12-19-2010, 12:35 PM
  5. Replies: 2
    Last Post: 01-22-2010, 04:00 PM
  6. Replies: 1
    Last Post: 10-06-2009, 04:01 AM
  7. The last row of a pivot table shows blanks, but there is data.
    By D May in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-25-2006, 08:35 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