
1. Re: KPI indicator
Adam Crahen Sep 19, 2016 5:42 PM (in response to Anna Kisting)Hi Anna
How about this one:
MAX({fixed [Region], [Category] : SUM([current year])}) = MAX({fixed [Region], [Category] : SUM(IF [Category] = 'Technology' THEN [current year] END)})
Compares the Max sum(current year) vs. the Tech total for a Region/Category.
This uses a few tricks. I put MIN(1) and MIN(1) on a dual axis to give a separate marks card. This allows me to put two columns of shapes in the same space as the bar chart. I formatted the axes to remove the tick marks and title on the bottom axis. The field labels are just spaced out in the top axis title. The divider uses the zero line.
I also put current year on a dual axis so I could shrink the height of the axes. The title on top is the text with ticks off. The title is off on the bottom with ticks on.
9.3 workbook attached.

Superstore (1).twbx 426.0 KB


2. Re: KPI indicator
Anna Kisting Sep 20, 2016 2:05 PM (in response to Adam Crahen)Thank you so much for your help!
I ended up using this slightly altered one:
MAX({fixed [Region], [Category] : SUM([current year])}) = SUM(IF [Category] = 'Technology' THEN [current year] END)})
I really appreciate that you took the time to show me another way to show my KPI's. Now if Tableau would only let me resize individual columns...
Anna