cancel
Showing results for 
Search instead for 
Did you mean: 

Contribution function returning wrong values

amelia
8 - Cloud Apps
8 - Cloud Apps

Hi all, as seen in the screenshot, I would like to get percentage values for each cell based on the grand total. However, when I use Contribution(), it returns the percentage relative to the total per column. I would like to get the total based on the table, rather than each column. Can anyone advise? Thank you 

1 ACCEPTED SOLUTION

irismaessen
9 - Travel Pro
9 - Travel Pro

You can always calculate the contribution yourself, especially if the formula you are using is not too complicated.

Including the ALL(columname) as a filter on your formula means that all values from that column will be considered in the calculation. So you can use that to calculate a contribution.

For instance: SUM(sales)/(SUM(sales), ALL(Months in Date)) will calculate the percentage of Sales in a given month over all months.

For your situation, you can apply the ALL() filter for both your Rows grouping and your Columns grouping.

So  your Values formula becomes something like: SUM(Sales)/(SUM(Sales), ALL(YourRows), ALL(YourColumns)

View solution in original post

2 REPLIES 2

irismaessen
9 - Travel Pro
9 - Travel Pro

You can always calculate the contribution yourself, especially if the formula you are using is not too complicated.

Including the ALL(columname) as a filter on your formula means that all values from that column will be considered in the calculation. So you can use that to calculate a contribution.

For instance: SUM(sales)/(SUM(sales), ALL(Months in Date)) will calculate the percentage of Sales in a given month over all months.

For your situation, you can apply the ALL() filter for both your Rows grouping and your Columns grouping.

So  your Values formula becomes something like: SUM(Sales)/(SUM(Sales), ALL(YourRows), ALL(YourColumns)

amelia
8 - Cloud Apps
8 - Cloud Apps

Thanks so much, it helps 🙂

 

Voice of Customer
Impact Business Intelligence (BI) and Analytics Market Research

Click Here & Complete Dresner's Wisdom of Crowds® Market Study Survey Today!

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request

Don't miss out:

Earn a BETA Launch Challenge Badge!