Heat Map Table

[evansabres]

I have a field called 'mjrGRP'

There are values in this field of 'Food' 'Beer' 'Liquour' 'Wine'

The metric for this field is another field called 'salesTTL'

Sample data:

mjrGRP               salesTTL

Food                    12.00

Food                    20.00

Beer                     8.00

Liquor                  10.00

Wine                    9.00

I want to create a table that has an equation for each mjrGRP, I already have the expression(s):

=NUM(Sum({<majorGRP = {'Food'}>}salesTTL), '$##,###.##')

What I want to do is create a table that has the salesTTL for each mjrGRP in four separate columns.

So My table would look something like below

                                   Food          Beer               Liquor               Wine

Sales by Group        $50,000     $45,000          $30,000               $10,000

Then, ideally, I would like to make this look like a heat map

[sunny_talwar]

May be create a pivot table where mjrGRP is the pivoted dimension?

[evansabres]

I was able to use a straight table by having the dimension =If(not Match(majorGRP, 'Food', 'Beer', 'Liquor', 'Wine', 'Retail'), majorGRP) and then the expressions as above. Still looking to accomplish the heat map

[sunny_talwar]

Why don't you try with the pivot table?

[evansabres]

Will that allow for the heat map? I have a working solution for the first question

[marcus_sommer]

Maybe this is helpful: The great heat chart.

- Marcus

[sunny_talwar]

It should.... marcus_sommer‌ shared a link where a pivot table has been used

[evansabres]

For my data, the straight table is working better.

Is it possible to have the background of each cell in my table show a color in relation to the total.

My equation for a particular majorGRP is =NUM(Sum({<majorGRP = {'Food'}>}salesTTL), '$##,###.##')

So I am thinking that divided by NUM(SUM(salesTTL) to show the percentage of sales?

[marcus_sommer]

I think it should be possible also with a straight-table and but suggest that you start to understand the logic with the example-pivot and then adapting it to your goals.

- Marcus