Syntax - Share % Calc using Direct Discovery with Oracle DB

[#1]

Direct Discovery

Oracle DB

How do you get the denominator of the share % calc to ignore Product dimension.

Sales Measure:

Sales	Time
Product	May	June
A	10	30
B	15	20
C	13	21
D	19	32
E	18	54
Total	75	157

Desired output (Denominator for Share Calc):

Sales	Time
Product	May	June
A	75	157
B	75	157
C	75	157
D	75	157
E	75	157

How do you get this in an expression.

AGGR(SUM(Sales),TIME) is giving the desired number but it displays only under one Product. As in, I get the below output:

Sales	Time
Product	May	June
A	75	157
B	-	-
C	-	-
D	-	-
E	-	-

What is the syntax to ignore Product and get the desired output?

Thanks in advance.

[sunny_talwar]

So if there are three different charts, why are you looking to combine these three?

AGGR(NODISTINCT SUM(Sales),TIME)

AGGR(NODISTINCT SUM(Sales),REGION)

AGGR(NODISTINCT SUM(Sales),TERRITORY)

I guess I am having difficultly understanding the final goal here