Pivot Table not Summing

[dwfiv327]

I have a pivot table with several expressions.  On all of them I switched over to straight table view and selected SUM for Total Mode.  The totals are correct.  When I switch back to Pivot table, one of the columns gives me the Expression Total instead of the sum. 

How can I force the pivot table to SUM the expressions instead of computing the Expression Total?

[Anil_Babu_Samineni]

May be in Pivot table you need some aggregation like Sum(your expression) or Sum(Aggr(your expression), dimensions))

[dwfiv327]

Should not matter what formula I use for the field, when I ask for totals to be SUM of field, it should give a SUM and not reevaluate the formula for the total.  It is looking like a bug in QlikView.

[Anil_Babu_Samineni]

Can you please post atleast snap for that?

[el_aprendiz111]

Hi,

[dwfiv327]

Yes, I have "Show Partial Sums" checked, but the Pivot table does not sum the column, it computes the formula on all entries in the column, which is not the same thing.

How do I get it to actually SUM the column?

[el_aprendiz111]

Hi,

You do not have a qvw sample to help

[dwfiv327]

Here is a little sample that illustrates the problem.  The sum of the expression in the Pivot table and in the Straight table are not the same.

[el_aprendiz111]

Hi Daniel

Expressions:sum(Aggr(sum(Value)/sum(Month),Name))

[el_aprendiz111]