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.
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
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