Control for date granularity for Pivot table

Q&A
,
2

@Leon - I believe you can do it using parameters. Please go through the following link where a similar problem statement has been resolved. you can apply the same technique in your pivot table use case as well. Hope this helps!