I am unable to calculate a total in a separate chart (not in the detail section) . The reason for a separate chart is the information in the detail chart is too lengthy and totals are not easily visible and user doesn't want to scroll over to the far right but wants a snapshot glance of the totals.
Please see the attachment that describes the issue in detail.
I have never used aggr function - fairly new to QlikView. Would you be able to provide one example with the details I had previously attached? I was able to perform one expression in the separate total chart based upon a RECEIPT_AMOUNT, so I thought I would be able to use all the dimensions. It was