Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to group choices in the filter pane?

Hello,

I have a report with a drop-down filter that shows the month-year as the choices. Please see screenshot here:

12_12.png

I was wondering, how can I set the filter up as to show the "Dec-2017" option to show only once, instead of many times as in the screenshot? How can I group this repeating label? Currently, I have this function in the field:

(Date([Opportunity.CreatedDate] - 5/24, 'MMM-YYYY'))

Thank you in advance for your assistance!

1 Reply
YoussefBelloum
Champion
Champion

Hi,

I don't think you can do this on the filter of the Table, you can add a "filter line" above the table and add the dimensions with DISTINCT..