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

# custom subtotal not working as expected

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

• ###### 1. Re: custom subtotal not working as expected

Hi Craig,

You may want to use the second recipe

(Customizing Grand Totals with Table Calculations)

from the foundational article by Jonathan Drummey :

Customizing Grand Totals – Part 2 | Drawing with Number

Yours,

Yuri

1 of 1 people found this helpful
• ###### 2. Re: custom subtotal not working as expected

Thank you very much, Yuri.  I was able to replicate what you did in your file.

After reviewing your work and watching a couple videos demoing the concept on YouTube, I think I have a better grasp conceptually.

Thanks again for your help and patience as I grapple with these concepts.  Appreciate it.