How to Add total and distribution field in pivot table?

[JaimeG]

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:

[MayilVahanan · Accepted solution]

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)

[JaimeG]

Thanks for the help Mayil Vahanan R