Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Struck in CSum

Struck in CSum

Struck in CSum

        I am struggling with Cumulative Sum in MicroStrategy based on combination of two attributes say BranchID and Date and also with CityId and Date i.e. i want to sum based on
ascending order of date.
This is the data I have:

BranchID    City        Date        Amount    

B1        C1        1/13/02        150    
B1        C1        1/14/02        150    
B1        C2        1/14/02        650    
B2        C1        1/15/02        300    
B2        C2        1/18/02        500    
B2        C2        1/19/02        500    
B3        C1        1/18/02        450
B3        C2        1/16/02        450

I am looking for a report like this with csum based on asc order of branch and date

BranchID    Date        Amount        CSum

B1        1/13/02        150        150
B1        1/14/02        800        950

B2        1/15/02        300        300
B2        1/18/02        500        800
B2        1/19/02        500        1300

B3        1/16/02        450        450
B3        1/18/02        450        900

i also want to do csum based on asc order of branch, city and date

BranchID    City        Date        Amount        CSum

B1        C1        1/13/02        150        150
B1        C1        1/14/02        150        300
B1        C2        1/14/02        650          650

B2        C1        1/15/02        300        300
B2        C2        1/15/02        500        500
B2        C2        1/18/02        500        1000

B3        C1        1/16/02        450        450    
B3        C2        1/18/02        450        450


RE: Struck in CSum

when you are in the metric editor, highlight the runningsum in the definition and rightmouseclick, select parameters.  You'll see a break by tab and a sort by tab.

for break-by select branch

and do the same for your sort by.  

You'll see it, it's quite intuitive, just hard to find.

RE: Struck in CSum

Dear gauge,
Another solution is to create a MTD (month to date) transformation table and add it to the metric.
However I thing that nlim solution is more polite.

Humberto Seiji Fukuda
If you need more instruction to solve it, contact me.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close