Display Total Minutes

[Anonymous]

I have a table that has the following expressions: Seconds and Minutes[( Seconds/60)]

I am struggling with:

- I only want to display Seconds for each month and calculate Total Seconds and only display  calculated Total Minutes next  Total Seconds as per below attachment:

• 

[ben_pugh]

Here's the qvw if you need it

[Anonymous]

Hi Ben,

Please find the example attached. I have tried Dimensionality but it still doesn't work.

[ben_pugh · Accepted solution]

Dimensionality() refers to the vertical dimensions (columns) of the table.

For a pivot table that is displaying totals by both row and column, you also need to use SecondaryDimensionality(), which refers to the horizontal dimensions (rows) of the table.

So basically we are saying for anything that is in either the totals row or the totals column, calculate seconds/60, otherwise seconds.

I've done this for you in the attached file. The formula is:

=if(Dimensionality()=0 or SecondaryDimensionality()=0,sum(Seconds)/60,sum(Seconds))

[Anonymous]

Thank you so much for your time Ben, this is what I was looking for

[ben_pugh]

Happy to help