I am having trouble creating the visualization I need.
Goal: Create and analyze three customer buckets - defined by contribution to total revenue.
I've attached a workbook that provides a rough picture with what I'm trying to accomplish. Note - the calculated fields use arbitrary values to weight the bar charts for a desired look. Ideally, I'd like to superimpose the average revenue per customer (line graph) on top of the total revenue contributed (bar chart) for each bucket using a dual axis. However, since I have three measure values which correspond to the primary axis, and three for the second axis, I'm not sure how to proceed.
Does anyone have any suggestions on how to approach this issue?