Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a table and i want the result shown below
Data Table
Required Output
Thanks
Rohit
Create a straight Table
Dimension = Bucket
Expression
SUM(No.)
and
SUM({1}TOTAL No.)-RangeSum(ABOVE(SUM(No.),1,RowNo()))
Hope this helps...
UPDATE:
There is another option..
RangeSum(Below(SUM(No.),0,Max(TOTAL Aggr(RowNo(),Bucket))))
Create a straight Table
Dimension = Bucket
Expression
SUM(No.)
and
SUM({1}TOTAL No.)-RangeSum(ABOVE(SUM(No.),1,RowNo()))
Hope this helps...
UPDATE:
There is another option..
RangeSum(Below(SUM(No.),0,Max(TOTAL Aggr(RowNo(),Bucket))))
PFA qvw
Hiya,
If you would like to add the other field (No.) as well, you'll have to do it in the expression (with no aggregation), not as a dimension (else the first value 347 will be copied all the way down).
I've attached a QV Sample.
I can not see your input data, but what do you think about using Accumulation property? (Properties/Expression tab - under expression list).
regards
Darek
Thanks to all
Regards
Rohit