Excel Forum



Excel Magic Trick 612: Pivot Table Year Over Year Sales Calculation From Dates Listed As Text


See how to create a Year Category for a Pivot Table from Dates Entered as Text using the RIGHT function and the Ampersand & (Join Symbol). Then we can calculate Year Over Year Sales showing Percentage Change using the Show Values As % Of Value Field Setting.





Got a Question? Ask it Here in the Forum.