The table calculations will not help you with getting the correct total in the 'total' section of the view, and it will be necessary to have the Distributors on the view. One possible option (instead of MDX) could be to use the running total and use the last line in the view (since this should have the correct total). Then, hide all the rest, by right clicking and selecting Hide. Then, hide the Distributor header. However, this solution is not dynamic and as any distributors are added to the view, they will then have to be hidden again. Hope this helps a little bit.