Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I know there's a accumulation function/options to select in Straight Table.
But when i switch to Pivot, i cant make any change on the accumulation option, cant select any.
Rgds,
Jim
How about if you do this:
RangeSum(Before(TOTAL [Standard Cost], 0, ColumnNo(TOTAL)))
Hi
you can accumulate by using expression
for example
rangesum(above(sum(sales),0,rowno()))
Jim,
Accumulation option will not be available in pivot table. Workaround is you have to user rangesum or other range functions. You may use above or below functions also.
Refer the following threads also
Accumulation in a pivot table | Qlik Community
Regards,
Siva
Are you still accumulating vertically or is the accumulation done horizontally now?
For horizontal accumulation, may be this:
RangeSum(Before(Sum(Value), 0, ColumnNo())) or
RangeSum(Before(TOTAL Sum(Value), 0, ColumnNo(TOTAL)))
For vertical accumulation, may be this
RangeSum(Above(Sum(Value), 0, RowNo())) or
RangeSum(Above(TOTAL Sum(Value), 0, RowNo(TOTAL)))
Hello Sunny, i will try it out 1st with your solution.
Thanks,.
Hey bro,
i have tried with the RangeSum(Before(Sum(Value), 0, ColumnNo())).
But looks weird on my pivot table. Or Do you have a sample qvw file that have applied with this expression so i can refer to ?
Rgds,
Jim
Would it be possible to share an image of what you are seeing. I want to see the weirdness you are seeing
Hi Sunny,
I am working with Jim on this issue.
This is the result that we get. the expression is look fine for a month, when trying to calculate for two month. the amount is incorrect for 2nd month.
the expression we are using is = RangeSum(Before([Standard Cost], 0, ColumnNo(TOTAL)))
How about if you do this:
RangeSum(Before(TOTAL [Standard Cost], 0, ColumnNo(TOTAL)))