Re: ytd calculation
From: raja <dextersunil_at_gmail.com>
Date: Thu, 4 Feb 2010 09:08:27 -0800 (PST)
Message-ID: <c2ad2b4d-2870-4156-8532-8bdd7a4348f6_at_b36g2000pri.googlegroups.com>
Thanks for your immediate reply.
Date: Thu, 4 Feb 2010 09:08:27 -0800 (PST)
Message-ID: <c2ad2b4d-2870-4156-8532-8bdd7a4348f6_at_b36g2000pri.googlegroups.com>
Thanks for your immediate reply.
I tried to do summation for month-wise ( using over clause - tried example query, is present in the above posts ) But, i dont know whether that is correct or not !!!
Now, i have to try another summation of the same type ; to get yearwise summation, with the data acquired from month wise summation, So, i want to rewrite a single query, so that, i get double summation for a column grouped by all the other columns.
Can that be done !!!! :-)
Hope you understand my need.
Thanks. Received on Thu Feb 04 2010 - 11:08:27 CST