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:
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.
Anyone an idea?