Skip to Content

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

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.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 26, 2017 at 11:18 AM

    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

    Add comment
    10|10000 characters needed characters exceeded