Can I use groups to create series?

Benny C

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?

Paul Newcome

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.

Paul Newcome

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.

Benny C

thanks @Paul Newcome

Paul Newcome

Happy to help. 👍️