Calculation based on previous member HELP

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: daveoram24@xxxxxxxxxxx
Date: 30 Oct 2006 06:45:05 -0800

Hi Everyone,
A sql Newbie here about to go nuts...

Ive been reading a lot of postings on the CurrentMemeber, PrevMember
functions but am unable to get them working.
Heres my problem.
In a table i have values based on an ID column, however there are some
IDs that have multiple rows..example below.
TABLE:
ID MarketValue
01 10000
01 20000
02 25000
03 15000
02 40000
Want it to look like:
ID MarketValue
01 30000
02 65000
03 15000

Now i was wondering how i can create a column either in this table, or
in a named query, which gives the total marketValue of each ID. Ive
been trying to use the PrevMember Function to compare if the
CurrentMemberID=PrevMemberID then if it does add the market values...

Any help is appriciated

.

Follow-Ups:
- Re: Calculation based on previous member HELP
  - From: Buelli

Prev by Date: Re: MDX Query for default dimension member
Next by Date: Re: The attribute key cannot be found (a new twist in the story)
Previous by thread: count date dimention
Next by thread: Re: Calculation based on previous member HELP
Index(es):
- Date
- Thread