Aggregation in Tableau

ATTR is also known as attribute function.  ATTR function is mainly used to aggregate the non aggregate values in tableau.in tableau if u want mix aggregate values in Tableau. In tableau if u want to mix aggregate to non aggregates we have to make use of  this ATTR  function.

                               
    Syntax:                                       ATTR(expression)


logic:


                        IF  max(expression)=min(expression) then expression

                                            else  '*" end

Rules:-

    1.We can't place one aggregation inside the other aggregation.

    2,We can't mix  aggregated fields with the non aggregated field.

    3.Max(sum(profit),sales)-------->invalid

     

    4.Max(sum(profit),sum(sales))-------->valid

    5.Sum(sales)*profits--------> invalid

     

    6.Sum(sales)*7---------->valid