Wrong total with Time

[#1]

Hi,

I have a problem with the Total in a pivot table when I want to sum Time. As you can see in the attached pic the Total is not the whole sum of the overlying rows.

How can I get the right sum in the Total? I use Time(Duration) in the scrip to get the right timestamp.

[justinasp]

Hi, Johanna,

in Chart Properties -> Expressions tab check Total Mode as Sum of Rows. I guess that is what you are looking for.

Goog luck,

Justinas

[rwunderlich]

Your duration column has Number format Time. It must be formatted as "Interval" to show a value greater than 24 hours.

-Rob