nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Multiple Aggregations within Cross Tab and Heat Map

tejusdas

Hi,
 
I have two questions related to crosstab design:
 
1. How do I show multiple aggregate values within the same cell on the crosstab grid?
 
In the attached example, say I want to display the aggregates of quantity, buyprice and msrp within the same cell. (Like cell B3 in the attached spreadsheet).
 
2. How do I do conditional formatting on the crosstab to generate a heatmap? Does anyone have any examples of this?
 
In the attached example, say I want to show a heatmap based on the Quantity aggregate, how would I do that.
 
 
I have attached an example report design using the classic models and also a spreadsheet of the desired result. Please let me know if you need any additional detail.
 
Thanks in advance for you time.
 
Cheers,
Tejus

Find more posts tagged with

Comments

shamo

Take a look at this if it serves your purpose and you can re format to suit you if it meets your requirement.

tejusdas

Thanks for your time, shamo.
 
I figured out that you can actually insert a grid element into the Aggregates area within the cross tab and then added the aggregates of quantity, buyprice and msrp by hand. That seems to have resolved the display issue.
 
As for the heatmap, I think the conditional highlighting logic you have in there will not work for me, since I want a value based gradient in every cell. There is also the constraint that i will not know the interval values at runtime so adding the highlighting rules would not be possible.
 
I think the only option is to get the max and min values for the dataset and then use javascript to come up with rgb gradient values.
 
Does anyone have an example of this?