Start a new topic

grouping query results by dragging

[This topic is migrated from our old forums. The original author name has been removed]

When I have odbc connections available I use a tool, aqt, that has a feature that i find extremely helpful for doing quick data analysis. A query result set can be broken into groups by drag columns onto a heading line. Groups can be collapsed and or expanded to find data in a large result set quickly by collapsing the groups and locate the first grouped column value and open that set finding the next grouped value etc.. Groups can also have there members counted, summed, etc. The heading line will look like Column1 --> Column2 ---> Column3 Thanks for your consideration
1 Comment

[This reply is migrated from our old forums.]

Re: grouping query results by dragging
Bill, You are probably looking into a pivot type of feature. I will add your vote for it. Thanks! Regards Roger