Total for each Date in pivot table

[kchamot]

I need to sum(value) for each date in pivot table

Data I got, rows is 'Type', columns is 'Date', measure is 'Sum(Value)'

	Date
Type	01.01.2025	02.01.2025
A	1	2
B	2	4
C	3	6
TOTAL	6	12

Output I need :

	01.01.2025	02.01.2025
A	6	12
B	6	12
C	6	12
TOTAL	6	12

What I tried :

	01.01.2025				02.01.2025
Type	Sum(Value)	Sum({<[Type]=>} Value)	Sum(TOTAL <Date> Value)	aggr(Sum(Value), Date)	Sum(Value)	Sum({<[Type]=>} Value)	Sum(TOTAL <Date> Value)	aggr(Sum(Value), Date)
A	1	1	18	-	2	2	18	12
B	2	2	18	-	4	4	18	12
C	3	3	18	6	6	6	18	12
TOTAL	6	6	18	6	12	12	18	12

What am I doing wrong ?

[henrikalmen]

Try Sum(TOTAL <Type> Value)

[Bhushan_Mahajan]

@kchamot I did below process:

1. Inline Load

ABC:
load * Inline [
Type,01.01.2025,02.01.2025
A,1,2
B,2,4
C,3,6
];

Then in the front end, take a table chart and put below expression.