Hi there,
try this:
RUNNING_SUM ( COUNT(1) )
Does it solve your issue?
Kind Regards
Alex
Hi there,
try this:
RUNNING_SUM ( COUNT(1) )
Does it solve your issue?
Kind Regards
Alex
Thank you for answer.
but my problem is not solved
I wanted this function because I wanted to count the number when sorting in an OLAP table like excel.
For example, if there are 50 rows, when desacending the casecount, I wanted to make it possible to see the index and think that there are 10 rows without counting the top 10.
Still, it was good to have time to study about running_sum, which I didn't know about. If you think of a new method, please leave a comment.
thank you. :D
Thank you for answer.
but my problem is not solved
I wanted this function because I wanted to count the number when sorting in an OLAP table like excel.
For example, if there are 50 rows, when desacending the casecount, I wanted to make it possible to see the index and think that there are 10 rows without counting the top 10.
Still, it was good to have time to study about running_sum, which I didn't know about. If you think of a new method, please leave a comment.
thank you. :D
You know, just in case you didn't know, I'll also leave the method I tried index order()