Toad World® Forums

Aggregate values in Results>Pivot

When I try to select multiple aggregate values in the Pivot section in the Results tab, I only see one column with one aggregate type. For example, if I select “Sum…” and “Average…”, both of them do not display, only Sum displays (because SUM was selected by default).

Is this a bug?

ag vals.jpeg

You are right, it looks like a bug. I created CR 111694 to track it.

In the mean time I’d suggest the following way around. Add the same field several times to the SELECT clause of your query, execute the query and add these fields to the data area. In this case you’ll be able to set aggregate functions independently.

Thanks Aleksey.

this is in a third party control we use. I am not sure we can fix it quikly.