show total in last row pivot table

[Singaravelu_R]

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.

[AshutoshBhumkar]

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