In the measure settings window choose the table Sales_data as the location to store the measure. If you selected of Parent Row Total from the Show values as drop-down list in above Step 5 you will get the percent of the Subtotal column. Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF ROW TOTAL calculation.
To use the data from another field in the formula click the field in the Fields box and then click Insert Field.
By adding running total to a pivot table we can track amountvalues cumulatively which is quite useful while tracking sales budgets interest values etc. Add Department as a Row field. Ill create my Value as percentage of Another Column Total which is Expenses Revenue Grand Total. This option will immediately calculate the percentages for you from a table filled with numbers such as sales data expenses attendance or anything that can be quantified.