1. Create a parameter called 'metric', set it to type string and set it up as a list with values like sales and profit.
2. Create a calculated field with a formula like
if [metric] = 'sales' then SUM([Sales])
elseif [metric] = 'profit' then SUM([Profit])
3. Drag the new calculated field onto the color button on the marks card. Make sure you remove your existing reference to Sales or Profit on your map
Thanks for the fast response.
I am familiar with using a parameter to select the filter. What I want to do is use both. I want to color with Profit, and when I select the marks it shows the total with Sales $.
What seems to be happening with the Summary card is that fields are added is somewhat alphabetical order when initially placing them. So I create a couple called A1, B1 and I can now make A1 point to Sales, and B1 point to Profit.
This allows me to color with Profit, but group select the marks total shows in units of Sales $.
My trick seems sort of kludgy.. wonder if there is a better way to do this?
Sorry, but I have no idea what A1 and B1 reference.
Looking at the example you attached, it seems to be working exactly as you described your requirement. The zipcodes are filled using the profit number and when I hover over the area I see the profit and the sales number in the hover.