Forum Discussion
Sumx with maxx wrong total
Hi Can anyone help correct this measure? Each campaign is given me the correct figure as I only want the latest. But the total is wrong, it should be 5.462 istead of 6.952 B2B leads lat...
thanks anyone with a solution to my specified formula?
Dennis_Pedersen It's difficult to know the specific solution becasue I'm not sure of exactly what your hierarchy is within your matrix. I see that you have a campaign_segmentid column and a Date column but it looks like there are additional levels to your hierarchy. So, without all of the information necessary, it's difficult to know the specific solution that will work in your case.
Thanks there are not much more columns than that, but still th total is not correct ?
See below
