Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Your duration column has Number format Time. It must be formatted as "Interval" to show a value greater than 24 hours.
-Rob