Results 1 to 8 of 8

Thread: Pivout Table group specific period

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 07-09-2012, 11:26 PM #1
    Howardc
    Howardc is offline
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    14

    Pivout Table group specific period

    My company's financial year runs from Oct to Sept each year. I would like to set up a Pivot table to show the total Cost & NBV (New Book Value) per asset type for the 2012 Financial Year (Oct 2011 - Sept 2012)

    I have attached sample data.

    It would be appreciated if someone can assist me in setting this up explain how to do this
    Attached Files Attached Files
    Last edited by Howardc; 07-09-2012 at 11:29 PM. Reason: forgot attachment
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Distribute Debt Across Time Period Split A Number Based On Another Split Ratio
    By mahmoud-lee in forum Excel Help
    Replies: 5
    Last Post: 05-28-2013, 03:00 AM
  2. Excluding Records of one Table from the Other Table
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-17-2013, 12:32 AM
  3. Formualu to extract period vbased on values
    By Howardc in forum Excel Help
    Replies: 4
    Last Post: 11-23-2012, 09:53 AM
  4. How To Add A New Group In A Ribbon
    By Excel Fox in forum Excel Ribbon and Add-Ins
    Replies: 2
    Last Post: 09-16-2011, 07:57 AM
  5. How To Add A New Button In A Ribbon Group
    By Excel Fox in forum Excel Ribbon and Add-Ins
    Replies: 0
    Last Post: 04-09-2011, 01:13 PM

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
  •  

Forum Rules