Total Problem in Pivot table

[gizzel123]

Hi Guys,

I have a below PIVOT table.but my requirement is to get the total base on group as,

For each section,

a.      Total for Today = sum of all lines identified as “today” in the group.

b.      Total for Proposed = sum of all lines identified as “today” and “proposed” in the group.

c.      Total for Future = sum of all lines identified as “today” and “proposed” and “future” in the group.

Is it possible?  Please advise.

[PrashantSangle]

Hi,

Try

Sum(aggr(YourExpression,dim1,dim2))

Regards

[gizzel123]

Dimension is the same, i,e GROUP.

it has 3  sections, today, proposed and Future.

I want to have total like: a)  Total:today

b)  Total:today+ proposed

c)Total:today+ proposed+ future

[antoniotiman · Accepted solution]

Hi,

see attachment.

Regards,

Antonio

[svenkita]

Create a new expression

=RangeSum(Above(Total Sum(Cost),0,99))

This will give u a running total.

Hope this helps