Hi, Anaplanner friends
(Please refer to the attached excel file)
Here I have a source module with Region (List) in its Page and Customer (List) in its Row. The result module would like to have total sales (roles up to Total Region and Total Customer). When I tried to make a direct link (Sales by Customers.Sales) in Sales' formula of the result module, I got an error that goes "Automatic sum of Sales over Customer hierarchy is not possible as Customer does not have a built-in top level". Any pointers on this issue ?
I guess one possible solution for this is to add "Region" and " Customer" to the result module and show only Total Region and Total Customer. In this case, the same to be added to the source module "variable cost" ??
Your support much appreciated. John W