web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Quarterly Filter in View Creation

(0) ShareShare
ReportReport
Posted on by

Is there any way when creating a view for a graph, to make one the filters update on a quarterly basis? ( I am aware of the "Created On" filter, I was just wondering if there was something else that might do the trick.)

Like a view that shows data at the end of every quarter?

Any help would be much Appreciated,

Thank you 

I have the same question (0)
  • Verified answer
    Wahaj Rashid Profile Picture
    11,321 on at

    Hi,

    You can use Fiscal Periods to filter the records (dynamically) for a quarter in a view:

    pastedimage1596645058175v2.png

    You can set your fiscal period to Quarterly in order to apply quarterly filters:

    pastedimage1596644980270v1.png

    For example if you need to list opportunities closing this quarter, we would apply following filter:

    pastedimage1596645131027v3.png

    This way, you will have a dynamic filter for a Quarter.

    Best,

    Wahaj

    (if it answers your query, mark this answer verified)

  • Anthony Dong Profile Picture
    on at

    Verified Wahaj's solution , it works

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 170 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 70

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 50 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans