5 Replies Latest reply on Jun 19, 2012 1:49 PM by John Munoz

    Showing cumulative total and most recent day's total within groups

    John Munoz

      Hi All,


      I've attached a workbook with some synthetic data. The data illustrate a problem I'm unable to work through.


      I want to create a worksheet that shows, for each segment, a cumulative count of widgets and a daily count of widgets. So, for each segment, there will be two rows of data, daily total (non cumulative) and cumulative total (which includes the current day).


      The worksheet might look something like this:



      Further, I'd love to enable the user to click on something and have the daily details for each segment show up, that's a nice to have, not a need to have at this point.