If you are looking for percent-of-total based the overall total in your data set you can use SUMMeasure. The basic formula to do this is Part Whole Percent You then format the cell as a percent. Percent and the partial amount are given and are known quantities Cross multiplying and solving for x gives the value of the total amount.
PartTotal100 Lets do this in excel.
From Visualizations tab select Table option and make sure you select all the fields from Fields On Report tab you should see data as below Now we will add a new column to calculate Percentage. If B is 75 and C is 69 enter C2B2 in column D to get 92. To convert a percent to a decimal multiply it by 01 or move the decimal two places to the left. If you want to buy a shirt that is 30 off the opposite of this is 70.