Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Like this?
create expression like below
aggr(sum(SALES),SALESMAN)
Like this?
OR
Sum(Aggr(sum(SALES), SALESMAN))