This content has been marked as final.
Show 3 replies
-
1. Re: Aggregating calculated results
Bill Saltmarsh Dec 18, 2015 10:44 AM (in response to Nick Sherriff)1 of 1 people found this helpfulHi Nick,
You were almost there! For the view in your attached workbook, this'll give you what you're looking for:
Hope that helps.
-
2. Re: Aggregating calculated results
Derrick Austin Dec 18, 2015 10:48 AM (in response to Nick Sherriff)Hey Nick,
Try this:
RUNNING_SUM(SUM([Sales]))/RUNNING_SUM(SUM([Quantity]))
- Derrick
-
YTD Agg Calculation.twbx 1.2 MB
-
-
3. Re: Aggregating calculated results
Nick Sherriff Dec 18, 2015 11:42 AM (in response to Nick Sherriff)
Guys, thanks so much! This worked like a charm.