The use of cross tab or cross tabulation is to show the joint distribution of two or more variables. Similarly, you can have your customize cross tabular report based on your data. Suppose, in Helical Insight, using Adhoc a cross tabular report is generated.Default view of Cross Tab
The above cross tab tells you about total cost involved for particular journey. As a business user, if you want to identify the cost involved for a journey is above or below budgeted cost then you can apply a conditional formatting.With the use of scripts you can generate an intended output.
Apply the script to generate the output
Similarly, you can apply more color customization or define the range. For more info, reach out to us at firstname.lastname@example.org