without trying, just having a punt - have you tried without the rollup() ?
Yes. Without the rollup() I will get 1 on each rows. but the problem I am having is how to reference the row where there is a sum.
I mean still use group by, but without the rollup
group by ticket
I've never seen rollup used in a chart like this.
That being said, you may be interested in
I got it , It works the way I wanted to work.