I'm my example I have used a technique that involves creating dual axis's using the AVG Number of Records which allows you to place your dimensions on the field for you to be able to color them based on a case statement.
Category was used for color in my example, but in your case, it would look something like this:
when 'centralized JNJ' then 'green'
when 'centralized competitor' then 'red'
I have attached a packaged workbook (v9.0)
Hope this helps.
Color Fields.twbx 1.1 MB
1 of 1 people found this helpful
I've tried recreating the same approach with your data set, but it doesn't seem that the data is consistent.
The values for 'Specialty' do not show as you had described in your calculation in your post.
You may have to create some logic to determine those values. Currently, 'Specialty' only includes; Null, All & Electrophysiologist (EP).
Thanks for the reply. I need to get the Header name? is it possible.
and I have almost 12 columns in my sheet. Can i apply the same logic using avg number of records?
Yes, you are able to show the headers. I hid them in my example.
To set up your headers so that they have the proper name you will have to right click on your top axis, click Edit Axis, change 'Title' to the name of you measure in that column, then, under the Tick Marks tab, select 'None': (select 'none' for both axis's)
Now your header will show:
I've used this method for reports with many columns, so 12 should be fine.
Hope this helps