I have a pivot table that has a date field as the Columns. Right now it’s aggregated in months but I also want to offer the ability to aggregate in days when the dashboard is published.
So is it possible to have a filter/dropdown on the dashboard to switch between month and day and it will re-render the table accordingly?
@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!