Former Member

# Runnin Total value mismatched in Sectioning

Hi Experts,

Am using 2 Dimensions(Say A&B) & Running total of one particular measure(C).

When 2 Dimesions(A&B) are in the Table level, Running total of particualr Measure(C) is showing Exact value.

But, if one of the dimension is on the Sectioning.. Running Total value changed....

Anyone, Pls, help in this problem....

Chithra

10|10000 characters needed characters exceeded

### Related questions

• Former Member
Posted on Dec 13, 2011 at 12:04 PM

Hi T Chithiraiselvi

Suppose You have kept dimension A as sectioning then use formula like

=Runningsum(c;A)

then it will calculate Cumulative values of this measure C and reset at each section .

hope this helps

Sunil

10|10000 characters needed characters exceeded
• Former Member
Posted on Dec 14, 2011 at 03:05 AM

Hi Chithra,

How you are expecting runningsum exactly?

if you want each section starts with new(starts from first row measure in section) runningsum, hope below formula will help you

=RunningSum([Measure];Section) OR =RunningSum([Measure];([Sectioned field]))

If you want continuous RunningSum just use below formula.

=RunningSum([Measure])