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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

How to Calculate Year-Over-Year Percentage Change in Management Reporter

(0) ShareShare
ReportReport
Posted on by 297

I am calculating average wages for a 3-month period for years 2019-2022. I would like to add a percentage row under sub-totals/total for 2020, 2021, and 2022 to show the year-over-year change (2020 vs. 2019, 2021 vs. 2020, and 2022 vs. 2021).  How do I do that?

These are my Row and Column Definitions:

2746.row.png

5460.Column.png

Categories:
  • Greg Byer Profile Picture
    2,588 on at

    There's not really a good way to do this.  Rows do not have a way to specify periods or years, like the column definitions do.  You could force an amount with a force calculation, but I'm not sure if that would work in this case.

    pastedimage1663766615590v1.png

    Let's say that I wanted to force the 3,227.88 amount to another position in the report.  This amount is in Column E, Row 153.  To do that, I'd have to create a force calculation like this:

    pastedimage1663766692309v2.png

    This will force the amount into Column B, C and D.

    pastedimage1663766727037v3.png

  • Matilda Pollard Profile Picture
    20 on at

    I appreciate the information and advice you have shared for myccpay I will try to figure it out for more.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 282 Super User 2026 Season 2

#2
Aayush Tiwari Profile Picture

Aayush Tiwari 219

#3
Subra Profile Picture

Subra 211 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans