Skip to Content
0
Aug 24, 2023 at 06:03 AM

Calculated Column in Graphical Calculation View

136 Views

Hi,

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

image.png

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:

image.png

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.

Attachments

image.png (14.6 kB)
image.png (19.8 kB)