Merge Cells in pivot table

[Anonymous]

Hello,

I am trying to merge some cells on a pivot table, but i haven´t been able to do it.

¿Is there any way to do?

I attach an example of a pivot table.

SALESMAN	PRODUCT	KPI	sum(SALES)	sales
X	1	SALES	5	12
X	2	SALES	7
Y	3	SALES	9	9

thank you

[devarasu07 · Accepted solution]

Hi,

Like this?

create expression like below

aggr(sum(SALES),SALESMAN)

[Anil_Babu_Samineni]

Like this?

OR

Sum(Aggr(sum(SALES), SALESMAN))