You want to isolate the Number of records (in the case of your example) so you would do
SUM(If [Category] = 'Furniture' then [Number of Records] END) //Or some variant of that...
You can then use that as a reference line.
Here's one way of doing it:
Create a calc field called Furniture:
and a calc field called Others:
Then put both of these fields on the Columns shelf as sums and select Dual Axis, sync the axes, and then hide the top axis. Set the color of Others to white, then go to the Analytics tab and drag Reference Line onto the Others - Cell spot.
Superstore.twbx 344.1 KB
^^^ THIS ^^^
I always forget about IIF(); Nice!
Thanks! this works. never heard about the iif and still dont really understand how it works. it says in the description that if will bring furniture back and others but in the same formula but i only see furniture in the calculated field