+ Reply to Thread
Results 1 to 1 of 1

Is it possible to do this with a Pivot Table?

  1. #1
    Registered User
    Join Date
    07-14-2012
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    11

    Is it possible to do this with a Pivot Table?

    Ive created some dummy data and layout, but the data source im using is very similar but with like 30 different columns and lots of data

    I was wondering if you can create a pivot table like the lower 2 parts of the image from the data set at the top.

    That is the diagram my boss gave me on how he'd like reports formatted. Im struggling to get row headings of a Value in money (Sum) with No below it as the number of occurences (count)

    Its possible just compiling a normal table with formulas, but i was wanting to achieve it as a pivot table where i could then easily seperate by month or region etc.

    Thanks in advance
    Attached Images Attached Images
    Last edited by reeyu; 07-30-2012 at 04:42 PM.

+ 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