Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Pivot Table filter by Year

    I have data that I have downloaded, that extracts all the years where there were asset disposals


    The current financial year start in Oct 2015 (year 2016) and as here have been no disposals for 2016 (shown on sheet "asset Disposals in Col O), I need the values on the Pivot table to be zero

    I have set up a Pivot Table and as there is no year 2016, do I just select blank or is there another way to do this using the Pivot Table?
    Attached Files Attached Files

  2. #2
    New Lounger
    Join Date
    Jan 2015
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    What if you add a row to the data where the description is Computer Equipment and the Period is 2016?

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Thanks for the reply

    I will work fine then

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •