Comparing an Individual Variance to a Group Total Variance

M_Johnson

Hi All, 

I am trying to compare a specific % variance, in this case one particular Car Dealer's Year on Year % Variance of retails, to the total regional % variance. Then a basic points based system will be applied if the individual Variance is greater than total regional variance

Some Sample Data is below, any help is much appreciated

Sample Variance Data.xlsx

Sebastiaandb

Hi @M_Johnson 

Not sure what you're looking for, i assume you want Alteryx to calculate the variances and give the points 🙂 (see attached). If not, let me know, i'm sure we can solve this!

Comparing_variance_question.yxmd