total sales of city group by country

[Anonymous]

i have dimension in qlikview with columns country, city, sales.

now i want total sales a city is doing.

how it is done in qlikview UI?

[balar025]

Can you please provide Sample data?

or sum(Total<Country> Sales) it will give country wise sum

[rahulpawarb]

May be this:

Aggr(Sum(sales), country, city)