1 Reply Latest reply on Mar 20, 2014 9:25 AM by jordan.bunker

    How can I link Date subtotals from the same table?

    Jacob Fink

      I would like to know how it would be possible to create a link between the subtotals of two date columns within in the same table. I have three columns, "Account ID", "Account Open Date", and "Account Close Date". Right now, I am able to easily tell how many accounts were created in each quarter by putting Quarter(Account Open Date) in the Rows shelf and summing up the number of records. I can also put Quarter(Account Close Date) in the Rows shelf to get closed accounts in each quarter.

       

      What I would like to do, however, is to link these two worksheets together and get a “Net Accounts Created” value for each quarter (sum of created – sum of closed).