Total columns using Pivot tables

[#1]

Good afternoon,

I am having an issue showing column totals for a particular dimension.

The process breaks correctly based upon the dimension as a total line shows up but the totals are not being displayed.

My expression just looks for the values of the dimension that I am interested in and that works.

I added a sum expression for the column that I am looking to total and I am not sure that I am doing that correctly.

Please help.

Thank you,

Mitch

[Oleg_Troyansky]

Hi Mitch,

it would help if you could post your application, or at least show your Expression formulas.

cheers,

Oleg Troyansky

[#3]

Table

Process ind        Start Value             Current Value

C                             100                         75

C                             10000                     250

C                             2000                       120

N                              100                         50

N                               200                          0   

N                              1000                    1000

In the pivot table I am trying to break on Process ind  and show totals for Start Value and Current Value.

[johnw]

The general form for sum totals in a pivot table is like this:

sum(aggr(Expression,Dimension1,Dimension2,...))

As Oleg suggests, we can't really give you the exact expressions without knowing your current expressions. But I'm going to guess something like this:

sum(aggr(sum([Start Value]),[Process ind]))
sum(aggr(sum([Current Value]),[Process ind]))

I'm not sure that I've understood the question correctly, though.

[Oleg_Troyansky]

The actual solution might be even simpler than that... If I'm reading the requirement correctly, this is what you need:

Dimension: Process (with the single dimension, this can be either a Straight Table or a Pivot Table)

Expressions:

     sum([Start Value])

     sum([End Value])

If you really want to show each value individually, then - yes, add them to the list of Dimensions, too. In this case, request "Partial Sums" for the Process on the Presentation tab.

I think your current problem is caused by the fact that you didn't use sum() in your expressions, and because of that the detailed lines worked just fine, but the totals showed nulls.

cheers,

Oleg Troyansky

[#6]

Thank you

Sorry for the delay.

I was able to get the totals Thank you

but lost showing each value individually

[Oleg_Troyansky]

As I mentioned in my reply, - if you want to show individual values too, then keep them as Dimensions and request Partial Sums on the Presentation tab of the properties.

[#8]

Thanks but even when I check Show Partial Sums I am just getting the totals.

Any other thoughts?

[Oleg_Troyansky]

Mitchell, you'll have to post your application to get more thoughts. We can't keep guessing what else is wrong with your pivot table.

[#10]

My only expression is

sum(aggr(sum(

would that be the issue