2 Replies Latest reply: Aug 18, 2009 11:59 AM by Matt Sweeney RSS

    Set Analysis - Sales Order Quantity Prior to Date Selections

      Hi all,

      In a Pivot Table I wish to provide:

      - Sales Order Quantity PRIOR to the Current Date Selections to provide an Opening Balance. The Date Selections are list boxes Month and Year.

       

      Sales Order Quantity within the Current Date Selections is easy of course, but i'm not sure how to sum the Sales Order Quantity for all Dates (Years and Months) Prior to the current selection.

       

      Any ideas?

      Thanks!