Results 1 to 2 of 2

Formula to give Day and Year from Date Range and include in Pivot Table

Threaded View

  1. #1
    Registered User
    Join Date
    07-24-2007
    Location
    London, England
    MS-Off Ver
    Office 365 ProPlus
    Posts
    80

    Formula to give Day and Year from Date Range and include in Pivot Table

    The enclosed file contains Data and a Pivot Table. Firstly, I would like the column L (Day) to contain a formula which will automatically show the day of the week based on the column B (Date). Secondly, I have a problem with the Pivot table. The Jan column is showing figures for both 2011 and 2012. How can these be shown separately, ie Jan 11 and Jan 12. Finally how can you change the order of the columns so that the latest month ie Jan 2012 is next to the Grand Total column and then working backwards by month. Any help is appreciated. Kevin
    Attached Files Attached Files

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