Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Linda,
It has cost me a neuron of my brain, but, after a long time analyzing your data, I found there are some RelatieRespPos nulls and others one repeated in Kanaal aanvraag, so I've changed all again and recalculated all the expressions, check out my example attached.
By the way, I'm not using the variable any more.
I hope this finally help you.
Best regards.
Hi Linda,
Could you please attach the demo data, to work on.
Thanks
sorry, attached the file.
thanks!
Hi Linda,
I don't know if this is what are you looking for, I hope it could be help you.
Best regards.
Many thanks the solution seems so simple
Hi,
I tried the solution at my customer but if failed on the results, see attached , i expect tot see the 83,4% of kanaal isstf ( 583/699 where the 699 is the sum of all the uniek relations within the different kanaals) , leaving the expression and turning it into pivot it's using the 583/649 where 649 are the unique realtions in the campagne ( not using the 699).
I need a calculation using the 699 ( sum of unique relations over the kanaals within a campagne)
Any idea how to establish this?
Kind regards, Linda
Hi Linda,
What about use a variable for the calculation?
See my attached file.
I hope this help you.
Best regards.
Hi Miguel, I am almost there many thanks this realy is a step forward, only thing which remains is that the total line at the end is not counting up to 100% I am not able to turn off the total line, any idea if we can make it display the sum of the values ( 100%)?
Many thanks for your help!
Kind regards, Linda
Hi Linda,
It has cost me a neuron of my brain, but, after a long time analyzing your data, I found there are some RelatieRespPos nulls and others one repeated in Kanaal aanvraag, so I've changed all again and recalculated all the expressions, check out my example attached.
By the way, I'm not using the variable any more.
I hope this finally help you.
Best regards.
Hi Miguel, you are my hero, many thanks for all your time and effort, this is the solution i needed.
Have a nice weekend!
Kind regards,
Linda