2 Replies Latest reply on Oct 13, 2016 2:47 PM by craig warpack

    custom subtotal not working as expected

    craig warpack

      Hello folks, I've been struggling for a  couple hours trying to get a custom subtotal that works, to no avail.  What I'd like is the % difference along quarters (across) and the subtotal to be the sum of those quarterly differences for the year.  I've tried doing it one formula after reading up on the matter.  The method I employed was if min(category) = max(category) percent change, else window_sum(percent change).

       

      For example, the subtotal for the year I expect to see is -36.3%.  All the numbers, however, are jumbled up.

       

       

      Thank you for your time and attached is a workbook (v9.3)..

       

      Kind regards,

      Craig