I am trying to create aggregate positive and negative variance buckets based on my Power Pivot dataset. The basic steps I am trying to achieve are below:
Step 1: Calculate a variance at an aggregate level, in this example “Group”
Step 2: Look at the variance associated with each group and...