Skip to Content
0

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

Jul 02, 2017 at 11:04 AM

53

avatar image

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.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Jul 03, 2017 at 01:51 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Vinod Patel Aug 26, 2017 at 11:18 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded