Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Is this possible to show total value as last row as per below table (highlighted in circle) . I have created pivot table but not sure how to show last row as total which is my client requirement.
Hi,
Not sure how this will work in your data model. Check out below sample dataset.
E.g
Date:
LOAD * Inline [
Mydate,sales,Product
23-10-2018,100,A
23-10-2018,453,B
23-10-2018,350,C
20-11-2018,200,A
20-11-2018,675,B
15-12-2018,300,C
];
Concatenate
Total:
Load * Inline [
Mydate,sales,Product
23-10-2018,100,Total
23-10-2018,453,Total
23-10-2018,356,Total
20-11-2018,200,Total
20-11-2018,675,Total
15-12-2018,300,Total
];
Output:
I generated the same values against dummy product 'Total'. Try creating in your data in such way.
Thanks,
Ashutosh