+ Reply to Thread
Results 1 to 3 of 3

Problem with Pivot table headings

  1. #1
    Forum Contributor
    Join Date
    09-05-2007
    Posts
    148

    Problem with Pivot table headings

    Hi guys, i'm having a little problem with a pivot table i'm trying to create, hopefully someone can help.

    If you have a look at the example file, Sum of revenue is seperated by quarter, but i do not want sum of approved to be seperated by quarter as well. I just want the total.

    Is this possible? How can this be achieved?

    Any help is appreciated.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-17-2007
    Location
    Washington, DC
    Posts
    103
    This may be over simplifying it... But you could just hide columns f through j

  3. #3
    Forum Contributor
    Join Date
    01-23-2006
    Posts
    194
    A method is to use an 'if' statement to create columns for Q1 to Q4 and display those values as per the attached.
    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)

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