This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Orderby and sum

Posted on 10-30-2022 02:09 AM
DonLV
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

Hi to all.

The result of my slice is a table with customer name - column 1 decimal value - column 2.
I would like the result of column 3 to be the sum of the decimal values, provided that the [_rownumber] <=[_thisrow].[_rownumber] in this slice

Solved Solved
0 1 84
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
dbaum
Gold 4
Gold 4
Reply posted on --/--/---- --:-- AM 
SUM(SELECT(SliceName[Column 2], [_ROWNUMBER] <= [_THISROW].[_ROWNUMBER]))

View solution in original post

Jump to Solution
1 REPLY 1

Posted on --/--/---- --:-- AM
dbaum
Gold 4
Gold 4
Reply posted on --/--/---- --:-- AM 
SUM(SELECT(SliceName[Column 2], [_ROWNUMBER] <= [_THISROW].[_ROWNUMBER]))
Jump to Solution
Top Labels in this Space