Percentages

insomned

Hello, 

I would like to find percentages of the points people earned for particular activities. Let's say:

Lisa           Swimming      4      350

Lisa           Flying jets     15      350

Michael     Swimming     10      490

Michael     Flying jets      200   490

I want to have different columns for Lisa Percentage Swimming calculating 4/350*100, Lisa Percentage Flying calculating 15/250*100 and so for Michael (and many many others). The last column is the total points of a person.

Thanks in advance!! 

mst3k

i think all you need is a transpose tool. i assumed everything here is already aggregate, i.e. lisa/swimming is only 1 row, you wouldn't have to add up multiple lisa/swimming rows. that's why i just chose "first" in the transpose, we aren't really expecting to do any aggregation in that tool at all.

Percentage_Transpose.yxmd