Jump to content


  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

MatthewK's Achievements

  1. Thank you for all your help, but ARGH! I feel so dumb. I have 3 groups in my table and this solution only worked for the 1st subtotal group. Groups 2 and 3 actually now have an undesirable result as some of the aggregates are now missing! I'm sorry if I'm wasting your time but I have no idea how to proceed...
  2. Absolutely! Aggregate 1 is very simple. It's just a sum of several fields Aggregate 2 is a bit trickier as I'm trying to get the % variance between This Year (TY) and Last Year (LY), 2 Years Ago (LLY), and Plan The formulas are working as expected, I just can't get your trick to apply to anything but the Report Totals. Thank you in advance!
  3. @CoopperBackpack thank you so much for your solution! I'm not the original poster but this helped me tremendously. Quick question: how do you get this to work for groupings in the table? The TOTAL row works great with var % showing up using your solution. But notice in the gray "group" rows underneath, the var % are not showing up (denoted by red x). Thank you in advance!
  • Create New...