You would create your calculated column in the data builder and aggregate that column in the data builder also. Then you would be able to create an aggregation of the new column when you access the data in designer.