I have a pivot table similar to below. Each person is given a score every week and I have the expression varX that calculates it. I show it below for clarity. I want to get a % of the scores within a performance range for each week. I will be working with four UNEVEN ranges. I tried the set analysis format below but it does not work. It returns a number but if I change the number the returned values don't change. I suspect its counting everything. Thank you in advance for any ideas.
Returns a number but changing ranges has no effect:
vTier2=Count({$<vScore={">.85<=.90"}>}Name)
Name
Week #
Person A
varX=.75
Person B
varX=.8
Person C
varX=.82
Person D
varX=.73
Person E
varX=.91
Person E
varX=.84
p.s. I am new to QV and find the syntax confusing with the use of single vs. double quotes and where to place symbols. So if you can explain any incorrect syntax I would appreciate it!
