Is there a way to sum columns in a BAQ without doing it through a dashboard view?
There are lots of ways. How would you like it to show up? The total (same number) on each line? Or just on line with the total?
I want to see it like it is above. I just want to run the baq and sum the column within the BAQ. I don’t want any extra columns added to the BAQ.
The BAQ grid can do the same thing as the dashboard one.
Other than that, no there isn’t a way to add another row at the bottom with the sums
Grid, I will have to research. Do you have an example.
It’s the exact same grid that is in a dashboard.
There IS a way, it’s just a bit hacky. You can add a union query with the totals, and an extra column with a manual indicator of whether a particular row is a detail one or a total, and enforce the ordering so the total always appears in the right place.
It isn’t often the right solution to the core problem, but it is doable.
1 Like
Ok. Yeah, that’s where I am at.
Thanks.