4 Replies Latest reply on Oct 17, 2018 11:23 AM by Jim Dehner

# Heatmap - Table down for label; Across for color

Hi,

I have a heatmap where I want to use a table calc to show the percent of total down the column.  However, i want to use the color to show how that number changes across the YearPeriod (color based on difference from previous cell).  If a group was 40% in YP1 but 39% in YP2, i want the color to get lighter for the respective group.  I attached a packaged workbook and a screenshot of my desired result.

• ###### 1. Re: Heatmap - Table down for label; Across for color

I'd suggest that you first create a calculated field to calculate your percent of total:

Percent of Total

// Calculate the percent of total for each year/period and group.

SUM([Sales])/SUM({FIXED [Year Period]: SUM([Sales])})

Then you can drag that to the color card and change it to a quick table calculation of "Difference".

See attached workbook.

• ###### 2. Re: Heatmap - Table down for label; Across for color

see the attached

this is the original % calc

this is the difference across

Place the difference on the color card

and it returns this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful
• ###### 3. Re: Heatmap - Table down for label; Across for color

Oh man! So simple, I got stuck determined to use table calcs.