Sum of values from Jan to Dec for current year and last year in Pivot Table

[KuppuswamyS]

Hello All,

      Can you please help how to sum Actual hours for current year(Jan to Dec) and previous year(Jan to Dec) and display it after plant column in the Pivot Table shown below?  Thank you.

[KuppuswamyS]

Hi Edwin, 

       Requirement is to show last year average hours and YTD average hours and current year months in columns.

       Please check the attached excel sheet. I'm using Pivot table chart to display months of current year,  last year average hours and YTD average hours in columns . 

         Thank you. 

[edwin]

normally, you cant have an expression outside of the pivots.  if you add the two expressions

Last Year Average Actual Hours YTD Average Actual Hours

it will be pivoted - you will get these for Jan, Feb, Mar, etc..

what you do is aggregate them and add them as dimensions.  this way the calculated value is not pivoted.  i adjusted the QVW to show you the total for prior year.  you can expand from that

[KuppuswamyS]

Hi Edwin,

    It works, thank you.