I need to be able to create a beast mode that does the following: for any given month sum up columns A, B, and C, then get the value D for the first day of the month, and implement the following formula:
(SUM(A) + SUM(B) - SUM(C) / D for the first day of the month
I can do it in an ETL, but that involves aggregations and the Powers That Be want to be able to drill down to the underlying values. Is it possible to get value D in a Beast Mode?