add a target on the pivot table

[n1ef5ng1]

is it possible to add a target (customized column) on pivot table in qlikview.

see attached.

i would like to add a hard coded 'target' in between Date and the city.

do note that i designed in a way that i need > 1 expression in the table. (i could have add city on dimension and expression to be sum(sales) but it doesnt work in this way).

let me know if it makes sense

[jimjimjim]

how do you open this file?