Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

using date ranges in calculation

I am trying to use a matrix table to show the following information:

Columns: Years (2016, 2017)

Rows: Salesperson, Month

Values: Sales, Profit, Budget


I am needing the create the following calculated columns and want them to be by month as well and appear in the proper column which would be my last year colum (2017)

% of Sales Budget

% of Profit Budget


Any tips on best way to go about getting this done?





Helpful resources

November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Kudoed Authors