25 Replies Latest reply: Dec 28, 2017 11:01 AM by Sunny Talwar RSS

    Count minutes per Day/hour/Month,etc

    JORDI TORRAS

      Dear Gurus,

       

      I'm struggling to find a calculation that seems easy but I cannot find our how to reach it.

       

      I have a pivot table with some Time dimensions (Month, Day, hours, etc) and some KPI's. I would like to add one KPI in this table to show me the total of minutes of my time selection. So, If I select "Day", I'd see in each colum: 1440 (24hours x 60 minutes). If I select Hour, I'd have to see 60*Number of selected Days. If I select Month, I'd have to see 43200 (30days -if that month has 30 days- x 24 hours x 60 minutes).

       

      How can I reach this calculation? Thanks in advance!

       

      Regards,

      Jordi