Sounds like a Table Calc might help here -- how familiar/skilled with Table Calculations are you?

Basically, you'd need to operate your calc within the pane, using some sort of WINDOW_ function, but that can get tricky if you're not sure what I'm talking about:

Table Calculation Functions

Difference between Pane and Table in Table Calculations

Hi,

Different ways to do this. Here is my approach based on pivot.

Create a calculated field to color.

Place this to color. You can make it continuous to get a sequential color range.

Let me know if that helps or not.

~Tushar

Like this?

Glad I could make it work

What exactly do you mean, change to percentage while they are text?

Do you mean tableau reads it as text (ABC) from your datasource?

Or do you want to show it as percent of total?

Or...?

If you do the calculation in a calculated field you can simply change the default number format to show it in %

--> 

If you do the calculation in the view do a right click on the number and choose format, then in Fields your calculation and in numbers you can change it to %.

  -->

hi Everyone - is there anyway to make the shading of my categories different? I'm trying to have each category have a different color - but when I change the shading it applies to the entire column.

End result I want is like the below: