Reply
Frequent Visitor
Posts: 2
Registered: ‎01-17-2017

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?