Forum Discussion

Claymation's avatar
Claymation
Regular Visitor
6 years ago

Sales Growth Contribution %

Hey everyone,   I am a first time poster here, and I have searched for what I am looking for, but haven't been able to find a solution.  However, if it has been solved before, please point me in th...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Claymation , Try like

% of Growth = divide([Sales Growth $], calculate([Sales Growth $] , allselected(Table))

or
% of Growth = divide([Sales Growth $], calculate([Sales Growth $] , all(Table))

  • Claymation's avatar
    Claymation
    Regular Visitor
    5 years ago

    Here is what I have as the two steps to get me there...however, when I compare to the solution that I have in Excel, it appears to be off.

     

    State % of Total = DIVIDE(
    SUM(location_sales_summary_v[net_sales_prev_day]),
    CALCULATE(sum(location_sales_summary_v[net_sales_prev_day]),all(location_finance_xref_v[state])))
     
    Then the following is what I am showing in the chart/table.
     
    SSS Contribution % (State) = [State % of Total]*[SSS Growth %]
     
    SSS Growth % is calculated as:
     
    SSS Growth % =
    DIVIDE(
        SUM('location_sales_summary_v'[net_sales_prev_day]),
        SUM('location_sales_summary_v'[net_sales_prev_day_prior_year])
    )-1