Pivot table Expression merge

[gireesh1216]

Hello Team,

I have raw data like below. Want to merge sum(sales ) expression in pivot table.

Thanks

Gireesh

[YoussefBelloum]

Hi,

try this:

=sum(total <APP> SALES)

this expression will give the exptected output, but it is not possible to merge cells on qlik

[shiveshsingh]

May be this

[gireesh1216]

Not working

[gireesh1216]

Thanks Singh,

Hear results coming in 2 times.I am looking only one time results like above.

[YoussefBelloum]

What is not working ?

can you attach screen shot of what you have so far ?

[sasiparupudi1]

May be try

[gireesh1216]

Thanks Sasidhar Parupudi,

But I am looking exact output like this.

https://community.qlik.com/servlet/JiveServlet/showImage/2-1473878-200136/pastedImage_1.png

[sasiparupudi1]

how about this

[Paknanarn23]

Hi, Sasiparupudi

How do you do this? please tell me