Hi fellow developers - I'm having an issue with some code (which I'm fairly sure, is fairly straightforward!) I just can't seem to get the syntax working!!
I have the following layout of data and I need to create a % pass against each measure:
As you can see each metric has it's own total value - so the measures that align to Cyclops_Address need to use the total for Cyclops_Address...the measures that align to Cyclops_DOB need to use the total for that etc.
I'm using sum(total but that's totalling everything together and not the individual metric totals.
Can anyone out there help please as this one is driving me crazy!!