Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a source
Product | Price |
---|---|
A | 100 |
B | 250 |
C | 150 |
But i want to display with extra column like this
Product | Price | Total |
---|---|---|
A | 100 | 100 |
B | 250 | 350 |
C | 150 | 500 |
How can I get total field by auto increment.
Hey Amar
Use this
aggr( rangesum(above( sum(Price), 0, rowno() )), Price)
Looks like duplicate thread!!
see also:
Check this out.
Use this as expression
RangeSum(above(sum(Price),0,RowNo()))