Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I need your help.
I am having a table which looks like this
!
but I would like to the it in this way
but also dynamically, so if I select Treaty 1 and 2 I want to see 1,2
also I do not want to use distinct, because bookings can have the same amounts for 1 Treaty
Any Ideas on that?
Regards,
Markus
Check attached
This?
Thanks so far, looks good for this small App, to bad it is not working in my bigger App, I try to give an example with more Data
Sure
please have a look at the new upload, thanks
Check attached
works so far, but you are using now distinct. what happens if I have exactly the same booking, Will I lose it?
I don't know what makes the unique combination where the duplication is present at? May be add them all as dimensions like this
Sum(Aggr(Amount, Loss, GenReUnderwritingYear, DimensionX, DimensionY...))
In my Database I have an SK for every booking, but when I use that Key I can not aggregate on Loss Level, can I?
All you need this is for the expression part... dimension's don't have to change.