• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Why % difference not comparing with any month of previous year in a pivot

Ram Mher

Member
I have a designed a pivot in which i want to comapre my all data with june 2014. result is reflecting only for the all motnhs of same year but when year change then resut is coming as NA. pivot sample is as below:-
Row LabelsSum of Ram
2014
May-15.10%
Jun
Jul-19.45%
Aug-17.74%
Sep-23.67%
Oct-8.92%
Nov-8.45%
Dec-2.25%
2015
Jan#N/A
Feb#N/A


Please refer the attached file and suggest the solution.
 

Attachments

Back
Top