Accumulate in Drill_Down group

[#1]

Hello

i have a drill-down group (year - month) in my QVD file

i wants to accumulate data just in month level not in year level,

how can i do this ??

best regards

hamide

[oknotsen]

I guess you mean you have both year and month fields in your data.

I suggest loading both dimensions in a pivot table and adding a "show partial sum" on the Month dimension.

If not, please give an example of your data and what you want to achieve.

[settu_periasamy]

Maybe try with 2 expression using Getcurrentfield() function.. like roughly..

If (Getcurrentfield('Groupname')='Month',accumulated expression, normal expression )

[HirisH_V7]

Hi,

May be like this,

Dimension:

Group - Year -Month

Your Expression:

=IF(Month,Rangesum(above(total Sum(Sales),0,rowno(total))),Sum(Sales))

HTH,

PFA,

Hirish