Pivot Table Question

[#1]

Hi,

I am new to Qlikview and I am stuck at a point. I am working on Pivot table where I need to display Total sales and sales percentage.The problem starts here, Sales and sales percentage related to a division for a year should be displayed in the same cell of pivot table.

I am attaching the qvw file and the expected output should be like displayed in jpeg file.

Thanks guys for your help

[settu_periasamy · Accepted solution]

Hi,

Try this if you don't get the solution..

remove the % expression..

The Sales Expression should be like

=Num(Sum(Sales),'#,##0')&chr(10)&num(Sum(Sales)/Sum(TOTAL (Sales)),'##,#0%')

[petter]

For me it looks like it works with your existing expressions - only move the dimensions a bit in the pivot: