Create Subtotal with break and measure in more universes

[former_member604110]

Hi everyone,

I try to explain my issue.

i have some universes:

1- first is the link between diferent id

Customer_Id ; Source; ID_Source

1 ; Source_1; A

1 ; source_2; B

1 ; source_3 ; C

2 ;source_2 ; D

3 ; source_1 ; E....

2- Measure for source_1:

ID_Source; Measure

A ; 10

E; 20....

2- Measure for source_2:

ID_Source; Measure

B ; 5

D;11....

3- Measure for source_3:

C;7

I create a merge on ID_Source for 4 universes.

Now i create a report with all data:

Customer_Id ; Source; ID_Source; Measure_S1; Measure_S2;Measure_s3;Total_Measure

1 ; Source_1; A;10;null;null;10

1 ; source_2;B;null;5;null;5

1 ; source_3 ; C;null;null;7;7

2 ;source_2 ; D;null;11;null;11

3 ; source_1 ; E;20;null;null;20

and I add a break of Customer_id.

Now, my issue is to have a subtotal by customer_id, because when a used Total_measure, it makes the total of Total_measure, but not the subtotal by customer of Total_measure.

Do you have a solution?

Thank you so much

[former_member604110]

Hi Amit,

I tried it, but it doesn't work.

The fact Customer ID is not in same universe as Measure create the sum of all measure, and not just Sum of measure for one customer

[amitrathi239]

After applying break then what is the total value is coming for customer id 1 and what is expected?

[amitrathi239]

try below formula in Total_measure column.

=sum([Total_measure] ) in ([Customer_Id] )