Subtotal one column of a table

[markperrone]

Date	Category	Total	Date total
1/1/23	A	5	35
1/1/23	B	10	35
1/1/23	C	5	35
1/1/23	D	10	35
1/1/23	E	5	35
1/2/23	A	5	10
1/2/23	A	5	10

How can make a table like this?  The total is based on date + category but the date total is based only the date

[Kushal_Chawda]

If your Total is expression in table.. (assuming, sum(Value)) ,you can use below expression for Date Total

=sum(total <Date>aggr(sum(Value),Date))  ---> Replace Sum(Value) with your actual expression

If Total is column or dimension in your table, use below expression

=sum(total <Date>Total)