Hi,
I am using my BW aDSO as source in Calculation View. In my aDSO, I have the following columns:

I want to create 2 new Calculated Column in HANA Calculation view to calculate the Total Sales by Store, and Total Sales by Country as following:

I have tried to use the Aggregation Node but just find it not possible to achieve this.
I wonder if we can create the Calculated Column and sum it by Store or Country?
The calculation is simple, Total Sales by Store for Store S100 = 1000 + 2000 + 3000 = 6000.
But this can't be done in the Calculated Column? or Even in Aggregation Node.
Any thoughts?
Thanks in advance.