Main Profile

At A Glance

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.
Length: 05:56

Contact

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

Want more info about Excel Magic Trick 612: Pivot Table Year Over Year Sales Calculation From Dates Listed As Text? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question