To eliminate the duplicate record in display of St Table

[Anonymous]

How to achieve the sum when certail dimension is need to have distinct values,based on the 'SUBMISSION'Id numbers all dimensions and meaures need to display the distinct Sum of measures.Can any one help on how to write this in case of If else Logic or any other way to achieve these?

Please look into the 'SUBMISSION'=173098570 is repeating twice in my data source how to eliminate the duplicate record in expressions and also in dimensions?Please do the needful?Thanks

SUBMISSION	FINAL	REPORT_DIV	LINE	EXPIRE	EFF_DT	GRS_WRTN	WRTN_ANN	Year	Month
173098570	A	21	Audi	1	05/01/15	1674	2224.356164	2015	4
695943290	A	21	Audi	1	05/01/15	5543	5543	2015	4
89716300	A	21	Audi	1	05/02/15	1841	1301.309589	2015	4
871874386	A	21	Audi	1	05/03/15	44812	44812	2015	4
970117696	A	21	Audi	1	05/04/15	3508	3508	2015	4
173098570	A	21	Audi	1	05/05/15	1674	2224.356164	2015	4
386046060	A	21	Audi	1	05/06/15	71093	71093	2015	4
754762885	A	21	Audi	1	05/07/15	12562	12562	2015	4
132635694	A	21	Audi	1	05/08/15	2500	2500	2015	4
528583353	A	21	Audi	1	05/09/15	24078	24078	2015	4

[Anonymous]

They have different values for EFF_DT so they are not duplicates per se.

[sunny_talwar · Accepted solution]

Use this as your expression:

=Sum(aggr(avg(EXPIRE), SUBMISSION))

[Anonymous]

Is there any other way to achieve these.For real data set i am not getting desired output.

Is there any possiblities to write logic of if else logic if(distinct(SUBMISSION),sum(GRS_WRTN),'')

Above is also missing logic can you pls correct me

[Anonymous]

Is there any other way to achieve these.For real data set i am not getting desired output.

Is there any possiblities to write logic of if else logic if(distinct(SUBMISSION),sum(GRS_WRTN),'')

Above is also missing logic can you pls correct me

[sunny_talwar]

I am unaware of another way to do this. May be if you explain what is still not working, we might be able to help you out.

Best,

Sunny