maybe someone can help with a problem. I created a table with one dimension (Customer_Item) and and two measures (Sales and total sales of costumer). I calculated the total sales of costumer with this formula:
aggr(sum(Sales),Customer)
But the result looks like this (see attachment)
I also tried aggr(sum(total <Customer> Sales),Customer). But the same result. I need the total sales of costumer in every row and not in a singel random row.
Next I tried to use this formula: sum(total <Customer> Sales)
This works if I use two dimensions (Customer and Item). But I need the ONE dimension Customer_Item.
aggr(sum(total <Customer> Sales),Customer) appears to be redundant as sum(total <customer>.. means aggr by customer. what you may want to try is add a nodistinct clause: aggr(nodistinct sum(Sales),Customer)
aggr(sum(total <Customer> Sales),Customer) appears to be redundant as sum(total <customer>.. means aggr by customer. what you may want to try is add a nodistinct clause: aggr(nodistinct sum(Sales),Customer)
