Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))