Issues with Totals in PIVOT TABLE

[#1]

Type	Sales
Total	40951.08
DISTRO	18047.27
DPUD	-68.16
REGULAR	40868.04

Hi,

This is the Data I am working on.when i click Distro alone i am able to get the correct total of it when expanded it gives all the data but when collapsed its not adding the DISTRO data but its adding all other data.Let me know whats the issue.

Thanks in Advance

[swuehl]

What do you get when you copy the expression in a text box?

In a pivot table, QV will calculate the total as expression total, while you might expect a sum of rows.

There might be a difference between the two, e.g.when a sales record can belong to more than one Type.

You can use advanced aggregation to get the sum of rows:

=Sum( Aggr( YourExpression, Type))