Extract a value from Report Filter

[gvaltat]

Hi,

Here is my problem. As explained in the title, I am looking for a way to extract a value from a Report Filter in a PivotTable. In the example attached, and for clarity, the date is in the Excel date-time code. What I am trying to do is to extract from the filter that the "minimal" date checked is 41451. I tried to play around with Getpivotdata, but with no success so far.
I would appreciate any help on this one.

Thanks,
Guillaume

[mahaveersomani]

check the attached file

If it was good then dont forget to hit * button for user reputation


Regards
CA Mahaveer Somani

[gvaltat]

Thank you for the help. Unfortunately, that is not was I am looking for.
Date can have 3 values (41450, 41451, 41452)in my example. In the filter, only 41451 and 41452 are checked. What I am looking for is a formula which will return the minimal value checked, here 41451. I have not succeeded to twist Getpivotdata for this purpose.
Value-from-Filter.xlsx