Supporting multiple auto calculation levels in a map

  • 2
  • Question
  • Updated 6 years ago
  • Answered
I like the auto-calc feature but would like to have multiple layers showing subtotals by branch and a final total. However a total auto calc topic includes ALL child values including the subtotals. Is there a way to filter out "child values" so only subtotal values ("parent values") are included in the total calculation ("grandparent value")?
Photo of James Simkins

James Simkins

  • 2 Posts
  • 0 Reply Likes

Posted 6 years ago

  • 2
Photo of Michael Deutch

Michael Deutch, Official Rep

  • 438 Posts
  • 75 Reply Likes
Yes and we're looking into making it easier for the future.

Basically, you have to start with a bottom's up approach and do a little editing of the display names to ensure each level calculates the level beneath it without duplicate counting.

Photo of Michael Deutch

Michael Deutch, Official Rep

  • 438 Posts
  • 75 Reply Likes
In the case above, I renamed mon. revenue which was calculated w. revenue. I created an autocalc at the quarterly level to calculate the Monthly revenue and then renamed the label as well.

You can edit the calculations by right clicking the label and choose the define option.
Photo of James Simkins

James Simkins

  • 2 Posts
  • 0 Reply Likes
Great, this works! Thanks and I look forward to future enhancements.

This conversation is no longer open for comments or replies.