Place dimension into the columns shelf Running Sum on measure in the rows shelf Secondary Table Calc - Percent of Total along table across or adressing dimension copy dimension into details shelf count distinct on dimension table calculation running totals on dimension secondary table calculation as a percent of total sort dims on details shelf in desc order by measure