Attached is my solution for calculating the trend (slope) of business departments' sales revenue over a 6 months window. I like you to review my expression to make sure that (1) it is written correctly for the intent and (2) if there is a more efficient or more straight forward way of forming the aggregation / calculation. Thank you.
The data dimensions are as follow:
Business Unit = department
Client Number and Sub Analysis = customer and product
RevenueDate = sales date
#RevenueUSD = sales amount
The task is to calculate the revenue trend of each business unit over the set period.