Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
They have different values for EFF_DT so they are not duplicates per se.
Use this as your expression:
=Sum(aggr(avg(EXPIRE), SUBMISSION))
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
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
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