Sort by aggregate in group or cube

Srividya Sharma

Hi

I have a table with Name and Amount.

I have grouped this by Name.

Then I create an aggregation Sum of Amount ( using palette ) and place it in group footer.

Now I want to sort this table by the aggregate Sum of Amount.

How can I do this?

Thanks
Srividya Sharma

mcremer

<blockquote class='ipsBlockquote' data-author="'Srividya Sharma'" data-cid="81005" data-time="1312341141" data-date="02 August 2011 - 08:12 PM"><p>
Hi<br />
<br />
I have a table with Name and Amount.<br />
<br />
I have grouped this by Name. <br />
<br />
Then I create an aggregation Sum of Amount ( using palette ) and place it in group footer.<br />
<br />
Now I want to sort this table by the aggregate Sum of Amount.<br />
<br />
How can I do this?<br />
<br />
Thanks <br />
Srividya Sharma<br /></p></blockquote>
<br />
You can add it to the sorting hoever you need to keep in mind that the GROUP you made is always stronger. Unleess you create the sum in data.<br />
<br />
But if you get your date trough a query you could also try using the folowing query method:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
SELECT SUM(a.colmun1) OVER (PARTITION BY a.colmn3 )IND_TOTAAL
FROM TABLE1 a
</pre>
<br />
This wil couse a sum over the group you want without making you have 2 group evry thing. (this will work for Oracle Databases and MS SQL Server (iim afraid its not psoible in mysql but there you could use a nother trick)).