Strange sum in Pivot table

[Anonymous]

Hello:

I need to do a strange sum on a pivot table,

this is the result i have:

SALESMAN	PRODUCT	KPI	KPI
X	1	SALES	5
X	2	SALES	7
Y	3	SALES	9
-	-	MARGIN	54

and this is the result i want:

SALESMAN	PRODUCT	KPI	KPI
X	1	SALES	5
X	1	MARGIN	54
X	2	SALES	7
X	1	MARGIN	54
Y	3	SALES	9
X	1	MARGIN	54

i attached the file with the example.

thank you

[marcelviegas]

all equal kpis have the same margin?

[sunny_talwar]

Something like this

[marcelviegas]

SEGUE ANEXO