I have a table chart showing Sales_person_id, Date_of_Sales, Sales_Amount, Sales_Currency columns.
I get this report generated via qlik ODAG, so at a time one report will have only one sales_person_id showing that sales person's all sales through out the years in different currencies (occasionally).
Most of the cases, one sales_person_id will have same sales_currency, but there are exceptions where one sales person sold in different currencies over the time.
I want to show the Total row at the top of the table like we show in qlik table chart, BUT Total value will show the total of Sales_Amount ONLY WHEN that table chart contain one single currency value.
If, that table has multiple distinct sales_currency value, the Total row will disappear.
