Hello,
I have an pivot table and calender object being date range picker extension in the sheet. What I would like to do is to set the default value of the calender object as "yesterday". I mean that when I open the app, I want to see the pivot table shows the results depending on the calender object being selected yesterday.
What do you offer to do this? Also, you can offer other techniques depending on adding somethings new to the calculation's expression of the pivot table.
Thank you.
