How to get the sum of the result in another column in HANA View

[former_member242633]

HI,

I show the overall results in the next column. i have single fact table.

for Exp

Dealer ID Prodution Month JC_COUNT SUM of JC Count

1010 201702 2 11

1012 201702 1 11

2013 201702 2 11

2103 201702 3 11

10001 201702 4 11

sum =11

How to get the Sum of jc count in calculation view.

[former_member242633]

Hi Rohit,

Actually I need show the Sum of the Result in next Column.

Group By Dealer and Prod Month

Here prod Month is Different

[rohit_chowdhury17]

Hi Vinood ,

Can you please elaborate the question a bit . By SUM of JC Count what do you mean ? The sum needs to be found on basis of broup by of the set (Dealer ID Prodution Month) or something else . Can you share the output you are expecting in a set format .

Regards

Rohit