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!
Yes, If I display the pivot table per day, I want to see 1440 (as it's the total of minutes in one day). If I display it per Year-Month, I want to see 43200 (as it's the total of minutes in one Year-Month). If I display the table per Hour and I filter, for example 7AM and two days, I want to see 120 (60 minutes per two days at 7AM).