qwerty

[Satish251]

.

[panosalexand]

Hi,
Please try the following. This is the way to compare YoY

2023
=sum({} [YourColumn])
2022
=sum({}[YourColumn])

% Different
(((sum({$} [YourColumn]))
-(sum({$} [YourColumn])))
/(sum({$} [YourColumn))))

[Satish251]

1. Hello Pansosalexand,

   Thank you for your suggestion.

   However, this won't provide a direct comparison. Please review the specified requirements below:

   *Present the average salary of employees who were part of the company in the preceding year and are still employed in the current year.