Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please find the attached image.
I have used max(Aggr(Sum(Sales),region,segment)) to get the total Sales by each region per segment. But the problem is i am getting the value only for one record and not for all. You can check it in the image.
My requirement is that the total for each region,segment should be displayed for each row.
Could you share the sample data
Source data ...
Is this the output you are looking for?
Per default aggr returned a distinct valuelist but you could add a NODISTINCT like:
max(Aggr(NODISTINCT Sum(Sales),region,segment))
- Marcus