Hi Everyone, I am currently trying to set up a dashboard with information which links to Pivot Tables which are in a hidden sheet. In this dashboard, I wish to use the GetPivotData formula to retrieve data in the table which exceeds the value of 72:00.
https://imgur.com/ccnYymS
As you can see by the above image, two values go over that threshold in the pivot and are highlighted. At the top of the table is the week number. What I would ideally like is for a formula which will show all the time in which a value has gone over the threshold of 72:00 within the last two weeks.
As a result, as a new week starts, the table shall follow . E.g, if thew current week number is week 6, the table will only show weeks 6, 5, 4 and 3.
Hope this makes sense, thanks you for the help.
As you can see by the above image, two values go over that threshold in the pivot and are highlighted. At the top of the table is the week number. What I would ideally like is for a formula which will show all the time in which a value has gone over the threshold of 72:00 within the last two weeks.
As a result, as a new week starts, the table shall follow . E.g, if thew current week number is week 6, the table will only show weeks 6, 5, 4 and 3.
Hope this makes sense, thanks you for the help.
