Pivot Table data doesn't stack up to 100%

ShellyG — Sat, 16 Nov 2024 18:29:24 GMT

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?

topic Pivot Table data doesn't stack up to 100% in App Development

Pivot Table data doesn't stack up to 100%