Row wise Total & Average in Pivot Table

[pasunurisandeep]

Hi Experts,

Is it possible to show Row-wise total & Row-wise Average in Pivot table.

Please find the below Excel for Sample.

Thanks in Advance.

Sandeep

[sunny_talwar]

Something like this?

Try script like this

Table:
CrossTable (Days, Value)
LOAD * INLINE [
    priority type, 1, 2, 3, 4
    P1, 10, 50, 20, 40
    P2, 30, 100, 30, 70
    P3, 40, 80, 60, 100
];

Dim:
LOAD * INLINE [
    Dim
    1
    2
    3
];

and then your row dimension

priority type

Column dimension

=Pick(Dim, Days, 'Total', 'Avg')

Expression

Pick(Dim,
Sum(Value),
Sum(Value),
Avg(Value))