Can I use groups to create series?

Benny C ✭✭

08/02/23 edited 08/02/23 in Formulas and Functions

I have this report

and from this I have created this Chart

but I want it to drill down to the show the individual Branches on a stacked column chart like this.

is this at all possible?

0 · Share on FacebookShare on Twitter

Sign in

Try for free

Best Answer

• 

  Paul Newcome Community Champion

  08/02/23 Answer ✓

  This isn't possible in a report. You would have to use a specifically structured metrics sheet with cross sheet references pulling in your totals.

  CERTIFIED SMARTSHEET PLATINUM PARTNER

  10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)

  Would you benefit from getting my help in person?

  0 · Share on FacebookShare on Twitter

Answers

• 

  Paul Newcome Community Champion

  08/02/23 Answer ✓

  This isn't possible in a report. You would have to use a specifically structured metrics sheet with cross sheet references pulling in your totals.

  CERTIFIED SMARTSHEET PLATINUM PARTNER

  10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)

  Would you benefit from getting my help in person?

  0 · Share on FacebookShare on Twitter
• 

  Benny C ✭✭

  08/03/23

  thanks @Paul Newcome

  0 · Share on FacebookShare on Twitter
• 

  Paul Newcome Community Champion

  08/03/23

  Happy to help. 👍️

  CERTIFIED SMARTSHEET PLATINUM PARTNER

  10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)

  Would you benefit from getting my help in person?

  0 · Share on FacebookShare on Twitter

Sign in

Try for free

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list