Aggregate per Material and Display by Month

[jorditorras]

Dear Gurús, 

I'm trying to apply a simple calculation (actually it's much more complex but I'm simplifying it just as an example) where I need to see the Billing Amount aggregated by Material. Something like: 

Sum(Aggr(Num(Sum( [Billing Amount in LC])), Material))

If I see the result in a Table and select one single month (like Fabruary 2023), the result changes as if I see in the table all the months of 2023 (the correct value appears when I select one single month). I attach two screenshots: 

And if I unslect fabruary, his result changes: 

Any idea about why this behaviour is happening??

Thanks in advance. 

Regards, 

Jordi 

[BrunPierre]

Sum(Aggr(Num(Sum( [Billing Amount in LC])), Month_ES, Material))