vendredi 26 juin 2015

Tableau possible IF LOD calculation

This one seems simple but I'm stumped. Hoping someone has come across this one before.

I want to show:

State Category Sales$ if Furniture is the highest Sales$ category for that State

I.e.

Arizona Furniture $13,525

However,if Furniture is not the top Sales $ Category I want to show 0 or NULL or "Red Flag"...any could work, "Red Flag" would be best but I'm not sure we can couple an agg with a string.

i.e.

Alabama Furniture "Red Flag"

thanks for any suggestions that get this right!

State Category Sales

Alabama Furniture $6,332 Office Supplies $4,209 Technology $8,969

Arizona Furniture $13,525 Office Supplies $10,006 Technology $11,751

Arkansas Furniture $3,188 Office Supplies $4,565 Technology $3,925

California Furniture $156,065 Office Supplies $142,352 Technology $159,271

Colorado Furniture $13,243 Office Supplies $7,899 Technology $10,966

Aucun commentaire:

Enregistrer un commentaire