Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a pivot table that shows the cases sold by month and by channel.
The formula I use to measure the pivot table is:
I want to add a total line at the end as well as the distribution of each channel over the total.
The table I want to obtain would be similar to the one in the following image:
Hi @JaimeG
Try like below
Island:
Load * Inline [
Dim
1
2
3
4
];
Create Dimension
CODE
Pick(Dim, CANAL_VENTA, 'TOTAL', '% venta par ecommerce', '% venta brokers')
Expression will be
Pick(Dim, ur expression, urtotalexpression, urpercentageexp, urventabrokersexp)
Hi @JaimeG
Try like below
Island:
Load * Inline [
Dim
1
2
3
4
];
Create Dimension
CODE
Pick(Dim, CANAL_VENTA, 'TOTAL', '% venta par ecommerce', '% venta brokers')
Expression will be
Pick(Dim, ur expression, urtotalexpression, urpercentageexp, urventabrokersexp)
Thanks for the help Mayil Vahanan R