
1. Re: Dividing one value by the sum of unique values
Zhouyi Zhang Mar 13, 2018 5:06 AM (in response to Tom Williams)1 of 1 people found this helpful 
2. Re: Dividing one value by the sum of unique values
Tom Williams Mar 13, 2018 4:33 PM (in response to Zhouyi Zhang)1 of 1 people found this helpfulHi Zhouyi
Yes th eindividual share measure can be displayed as a number (2 decimal points).

3. Re: Dividing one value by the sum of unique values
Zhouyi Zhang Mar 13, 2018 4:55 PM (in response to Tom Williams)Hi, Tom
Thanks for your explain, really helpful.
Please find my solution attached as well as screenshot below
Hope this helps
ZZ

Owner_link_subset.twbx 41.5 KB


4. Re: Dividing one value by the sum of unique values
Tom Williams Mar 13, 2018 6:13 PM (in response to Zhouyi Zhang)Hi Shouyi, that is not actually what I am after.
What I want is a calculation of how much of the total value of items that each individual is linked to. The ownership share should not be involve din the calculation. For example:
The total value of items here is $724,000. Jack is involved in the ownership of the Dining Set ($2000), the House ($500,000) and the PC ($1500). The total value of items Jack is linked to is $503,500. This means he is linked to 69.54% of the total value of items.
Does this make more sense? That is the calculation I am after but need to find a way to automate it for the entire dataset.

5. Re: Dividing one value by the sum of unique values
Zhouyi Zhang Mar 13, 2018 9:14 PM (in response to Tom Williams)2 of 2 people found this helpful 
6. Re: Dividing one value by the sum of unique values
Tom Williams Mar 14, 2018 2:08 AM (in response to Zhouyi Zhang)Zhouyi you are a wizard! That is exactly what I was after. Can you care to explain how the formula works to produce the correct answer? I still don't quite understand it.
Many thanks
Tom

7. Re: Dividing one value by the sum of unique values
james.williams.18 Mar 14, 2018 2:09 AM (in response to Zhouyi Zhang)Thanks for posting this, i was about to add a similar post. My one has some slight complexities though in that I want to be able to have the result recalculate if I filter what is shown based on a category.
I've attached an example workbook in which your calculations worked initially. But if i want to then filter out one category (say remove blue items from my example) the current solution doesn't recalculate to exclude the values which have been filtered out. Is there a way to do this?

Weight percent example.twbx 59.2 KB


8. Re: Dividing one value by the sum of unique values
Zhouyi Zhang Mar 14, 2018 5:37 AM (in response to Tom Williams)Hi, Tom
Glad it works.
The first part is easy to understand, sum up the total value for a person
The 2nd part is, as your data structure, the value per item is duplicated, so I need use average first, and then sum them up.
Hope this can help you better understand.
ZZ