Results 1 to 5 of 5

Pivot Table cleanup help needed

Threaded View

  1. #1
    Registered User
    Join Date
    11-05-2008
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    67

    Pivot Table cleanup help needed

    Hi Folks,
    In the attached spreadsheet I have a pivot table that shows the need over a defined period for inverters, there can be up to 3 inverters per order and I need to change the way that the item count is shown as its "too busy" for easy reading which is the aim of the pivots on this report.

    I am uncertain how to get the best result as the inverter type can change across Inverter 1, 2 and 3 as can be seen in source data in the sheet 'Today's Data'.

    Thanks in advance.

    Iain Kennedy
    Attached Files Attached Files
    Last edited by sarails; 01-19-2011 at 10:25 PM.

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