Summing Data - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Analysis Services (2000)

Summing Data

Author

Topic

MRIGUY
Starting Member

17 Posts

Posted - 2002-02-12 : 17:11:35

This query gives me the amount for each quarter.

Q1 50
Q2 100
Q3 10

I need to get a "running total" as the data is returned.

Q1 50
Q2 150
Q3 160

I'm not sure which function to use. I've looked at RollupChildren and Sum. I haven't been successful getting these to work because I'm not sure WHERE I need to use the function. Should it be in the calculated member?

Here's the query. Any help would be appreciated.

WITH
MEMBER [Account_dim].[BeginBal] AS '([Period_Dim].CurrentMember,[Account_dim].[R_EV])'
SELECT
{[BeginBal]} ON COLUMNS,
{[Period_Dim].[Quarter].Members} ON ROWS
FROM GHIS
WHERE ([Entity_Dim].[Entity Id].[0609])

Tim
Starting Member

392 Posts

Posted - 2002-03-06 : 18:55:25

have a read about the "PartialSum" function

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources