Skip to Content
0
Jun 02, 2020 at 07:32 PM

Show percentage of row total in heatmap

229 Views Last edit Jun 02, 2020 at 12:09 PM 3 rev

Hi,

I have created a heatmap (image below)

capture.png

The colors in heatmap for now are %grandtotal but I need percentage in each cell as a percent of row total. Example of data below

I have count (which is for each Ing_Product_Desc & SA_to_Prem bucket) but I would need another measure which is basically a count of SA_to_Prem_bucket under Ing_Product_Desc and calculate percentage.

capture2.png

Any help is appreciated!

Attachments

capture.png (40.3 kB)
capture2.png (21.0 kB)