I have attached the workbook with sample data with two sheets Sheet 1 shows what i am having.. sheet2 "color this as sheet1 view" shows what i want to achieve.
Here is the statement of my requirement:
I want to color the heatmap based on categories instead of count of data (which is in sheet1)... When i tried to color Heatmap based on category (with the help of calculated field).. i dont get the same view as i get in sheet1 (i.e. not complete row is colored in my required view). Can anyone help in achieving that?
Message was edited by: Tableaunew learning
2 answers