Forum Discussion
Heat Map alternate column values
Hello,
In Heat Map, I'm trying to achieve this, but not sure if this is possible. Can you please help me.
In Location (ID) - Given City name and Group by Country name. In the values I want to display all the $ (amount) columns in my table, one by one based on the selections. There are Sales ($), Lost Sales ($) and Excess Sales($) amount columns in my table.
If I select Sales column, I want to see the Sales ($) values and if I select Lost Sales column, want to see Lost Sales($) values and if I select Excess Sales column, want to see the Excess Sales ($) values.
If I drag the columns in Chicklet slicer, I can see the values of the column, but it should be sum(column values) on one click column name in slicers.
Is it possible, or any alternatives for this?
Regards
Kalyani L
Thank you for your suggestions, even I tried the same. As you said, only one value can be asigned to the map, and if I assign a new value hte old value will be replaced.
Thanks
3 Replies
Hi kalyani,
In Location (ID) - Given City name and Group by Country name. In the values I want to display all the $ (amount) columns in my table, one by one based on the selections. There are Sales ($), Lost Sales ($) and Excess Sales($) amount columns in my table.
By my test, you may cannot put severial columns in the Value. It only support a single column in the value, if you put another, the previous one will be replace.
If you have additional help, you could have a support from here.
Best Regards,
Cherry
Thank you for your suggestions, even I tried the same. As you said, only one value can be asigned to the map, and if I assign a new value hte old value will be replaced.
Thanks
Hi kalyani,
If we help you, please accept the reply as solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Cherry
