Select "last 3 months" from a date field for Pivot table filter

[jon.whisman]

Scenario:

Bot currently accesses an Excel and refreshes ALL external data connections and pivot tables in 2 worksheets. Bot then saves the file back up to the online reporting repository.

QUESTION / NEED:

Bot also needs to select the “last 3 months” in the “Created” (date column) that is used in the pivot table filters.

Screenshot attached of the need. Any thoughts?

[Anil_G (Anil Gorthi)]

@jon.whisman

Please try this activity

Activities - Filter Pivot Table

Cheers