<p>Hi,</p>
<p> </p>
<p>I have two questions related to crosstab design:</p>
<p> </p>
<p>1. How do I show multiple aggregate values within the same cell on the crosstab grid?</p>
<p> </p>
<p>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).</p>
<p> </p>
<p>2. How do I do conditional formatting on the crosstab to generate a heatmap? Does anyone have any examples of this?</p>
<p> </p>
<p>In the attached example, say I want to show a heatmap based on the Quantity aggregate, how would I do that.</p>
<p> </p>
<p> </p>
<p>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.</p>
<p> </p>
<p>Thanks in advance for you time.</p>
<p> </p>
<p>Cheers,</p>
<p>Tejus</p>
