cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KiDix
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?

 

 

 

0 REPLIES 0

Helpful resources

Announcements
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