Pivot Table Measure Display Only at Line Item Level
I am very new to Qlik Sense, and I am wondering whether there is a way to have a dynamically calculated Measure display at only the line item level of a Pivot Table. For example, can I calculate a range [max(ItemPrice) - min(ItemPrice)] only at the deepest aggregation level? Right now it simply displays at every level of aggregation, and at the highest level (Company) I see ranges of thousands of dollars when the actual line item ranges are very small.
As a possible workaround, is there a way to apply to a background color expression to the deepest aggregation level only?