Sum Aggregation in Table based on specific dimension

[AD24]

Hello Team,

Is it possible to perform sum aggregation over a specific dimension in a table?

The objective is to add this as a measure in two tables. Measure : Price *Qty

Table 1 : With Material field - dimension for aggregation

Table 2: Without material field added in the table but still the total remains same as table 1

[PrashantSangle]

Something like this

Regards,