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