While the calculated field has aggregation inside,
Tableau doesn't let you aggregate it again.
So, If you may try using window aggregation, you need to use such as window_Avg.
EXAMPLE:
First Calculation: Profit Ratio
sum([profit])/sum([Sales]) //Aggregate Calculation
Second Calculation: Avg of Profit Ratio
window_avg([Profit Ratio]) //Table Calculation
Get trained to use Tableau with full potential through Tableau Online Training.
Back