Forum Discussion
KiDix
9 years agoFrequent 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?
No RepliesBe the first to reply