accumulating sales using rowno

[#1]

Hi all,

I am using following formula for accumulate sales: RangeSum(Above($(vSalesACT), 0, RowNo()))  / SUM( total {$<DataCategory = {'ACT'}, Cat1_ID = {'1'}>}  $(=%VALUE))

Unfortunately the sort funktion is not working. Is there any trick to avoid rowno?

Rgds

SandMan

[varshavig12]

Peek() can help you.

Can you provide a sample data and the expected output ?

[varshavig12]

What you actually want to sum up,

sum of  $(vSalesACT) from its current position till ?Is it from the first row till the current position ?

Are you using a straight table ?

[#4]

I want to sum up Sales for selected stores --> 1st postion until last. yes straight table

[sunny_talwar]

You are doing this in which chart object? You might be able to use Aggr() function without script manipulation if you are using QV12

The sortable Aggr function is finally here!

[#6]

we are using QV 11

[varshavig12]

you can check the link posted by Sunny.

In case still you are stuck, then let us know by providing sample data.

[#8]

installed QV12. how should the formula look like?