Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
all equal kpis have the same margin?
Something like this
SEGUE ANEXO