One possible option may be to place the Customer Name on the level of detail shelf, then change the Yr to Yr Growth by Quarter calculation to Compute Using-->Customer Name. (Right click on the calculation to change this). Hope this helps!
Joe and Tracy,
Thank you both for the input and solution to my problem. One small question: I am duplicating the workbook approach that Joe sent using my real data. With level of detail at customer name level, my bar charts show tiny divider lines indicating each individual customer. Joe's solution chart was able to make these bars into solid blue lines. I am guessing that it is a formatting thing, but I can't find in format how to turn my bars from all the tiny divider lines into one solid blue line. Can you tell me how you did it? Otherwise, this is a great approach. Much appreciated!
Thanks for the Answer.
My question is, "how can you apply the buckets to Total Annual Sales.
For example, how many customers have "Total Annual Sales":
- Greater than $10,000
- Greater than $5,000
- Greater than $1,000
Below is what happened when I tried to do it.