Running total in Pivot Table

[dinuwanbr]

Hi All,

I have a Strange Problem. i'm Calculating running total and a contribution for branch and segment wise. The expression I used to calculate running total as follows.

RangeSum(Above(Sum(Net_Value),0,RowNo()))

But when i do'n select any Branch the result is wrong and when I select a branch the result is correct. But I need to generate that report for all the branches at once. (with out select any branch)

I have attached snap shots on both the cases. Unable to upload a sample.

Can anyone help me?

Thanx in advance.

Rgds,

Tharindu

[jonathandienst]

I expect you need a TOTAL statement in the expression:

RangeSum(Above(TOTAL Sum(Net_Value),0,RowNo()))

or

RangeSum(Above(Sum(Net_Value),0,RowNo(TOTAL)))

or some combination of the above

[#3]

try this i hope it will work

RangeSum(Above(Sum(Net_Value))

[dinuwanbr]

Dear Jonathan,

Thank you very much for ur reply. But still the same issue.

BR,

Tharindu

[dinuwanbr]

Dear Krishna,

Thank you very much for ur reply.

But it's not working.

Rgds,

Tharindu