Dear all,
I have an issue with a pivot table I created. I am using the following fields:
Rows - Country (the field only contains country names)
Column - Year (only years)
Measure - (sum({<Year = {'$(=max( {<Source={'Main'}>}Year))'}>}aggr(sum(Units), Year, Country))+sum(aggr(sum(ForecastUnits),Year, Country)))
/$(=sum({<Year = {'$(=max( {<Source={'Main'}>}Year))'}>}aggr(sum(Units), Year, Country)))
The results I get in the table are correct only when I select a specific country. The only problem is that Qlik Sense splits all the countries and the total of the countries is 100%. Instead I would like each country to be separately for itself 100%.
Any ideas on how to edit the expression?
