I've created a dashboard which details YTD figures. It includes a Radial Gauge. The issue I have is that the MAX Value is always detailing the SUM TOTAL of all Business Units - while the gauge meter updates according to each Business Unit's progress. I need the MAX Value to update for each Business Unit - and not detail the TOTAL.
Here's the data that should be reflected per Business Unit (as the MAX Value) each time a different Business Unit is selected. Again, currently, the Max Value only reflects the GRAND TOTAL for all units ALWAYS.
PlowShare - US: 0 Maxcess - US: 0 Publicis Resolute - UK: 0 Verilogue - US: 0 Real Science - UK: 0 Saatchi Wellness - US: € 6,493,802 insync - US/Canada: 0 Publicis LifeBrands Medicus - Japan: 0 Publicis Health - France: 0 Publicis Health Media - US: € 6,764,377 Saatchi Wellness - UK: 0 Razorfish Health - US: € 3,156,709 Saatchi Wellness - Japan: 0 Publicis LifeBrands London - UK: 0 Digitas Health - US: € 6,899,665 Digitas Health - UK: 0 Heartbeat - US: 0 PH Corporate: 0 Langland - UK: 0 Payer Sciences: 0 Publicis Health.Sapient - US: 0 Langland - US: 0 Publicis Groupe: 0