Any Ideas on this please?
You could try the following formulas when there are 2 zone records per name:
Formula to merge the zones:
if window_count(attr([Zone])) < 2
lookup(attr([Zone]), -1) + ', ' + attr([Zone])
Formula to merge the accompanying sales:
if window_count(sum([Sales])) < 2
lookup(sum([Sales]), -1) + sum([Sales])
Then put 'Name' and the zone merge formula on rows, and the sales merge formula in text. Put 'Zone' in level of detail. In the two formulas, go to compute using and select 'Zone' in there. As a last step apply the zone merge formula as a filter, and exclude the 'Null' in there. This should deliver the desired result.
Maybe that helps,
Hey Thank you!
The below calculation helped me better coz i have a huge data worksheet:
then "Zone 1 + Zone 2"
Was able to figure out later.
Thanks so much again!