How to perform a calculation using one variable with an aggregation in calculated field

Question

How to perform aggregation of one variable over total data using a calculation field? I want to calculate the average or sales in one region to total and show it in the tooltip,

Answer 1

Hi,

You can use the calculative field and Fixed Lod for your problem as

AVG(Sales) / { AVG(Sales) } where { AVG(Sales) } is avg sales for each region over complete data.

If you want to calculate for one region only then,

{ FIXED [Region] = "Canada" : AVG( [Sales] ) } / { AVG( [Sales] ) }