#DateForumTypeThreadPost
311 Feb 2015 @ 04:16 PSTAnalyticsReplyHow to get previous quarter total (SQL)Hi Dieter, Thank you for a quick reply. I did not think in this direction. I am still learning how you can use partition by approach properly. This does work, however, I was trying to avoid nesti...
210 Feb 2015 @ 06:24 PSTAnalyticsReplyHow to get previous quarter total (SQL)Sorry, tables do not look nice: TableA Customer Quarter Month Sales 1             1          1        0 1 &...
110 Feb 2015 @ 06:13 PSTAnalyticsTopicHow to get previous quarter total (SQL)Hello, I have a table with Customer, Quarter, Month and Sales (montly) figures. I need to calculate Quarter Sales and Previous Quarter Sales per Customer, while also showing Montly sales (see des...