Using button on a pivot table

[New-here1]

Hello All,

I would like to add a button to my app to filter out a pivot table but having some issues.

When clicking the button, I'd like everything that is conditional formatted in red for example, to show. Is there a way to do this with a button please?

The pivot table has dates in it and the date that is conditional formatted in red has the following formula:

IF([End Date]>AddMonths([Due Date],0),red())

So I would like when clicking on the button, everything that is in red, to show.

Thank you 

[Rohan · Accepted solution]

Hi,

Try something like this :

Create that If(End_Date>Due_Date,'Y','N') as flag in Backend 

Refer below image for Action - Selecting a value in Field & select Field as flag & value as Y.

Hope it works.

Regards,

Rohan.

[New-here1]

That worked, thank you @Rohan 🙂