Now press CTRL+1 to bring up the Format Cells dialogue box and make your formatting changes within here and press OK. Then you need to once again go to Pivot Table Tools > Analyze/Options > Select but this time select the Values STEP 7: To format the values you need to select the Pivot Table and go to Pivot Table Tools > Analyze/Options > Select > Entire Pivot Table So it will read the “ Difference from the previous Financial Year” STEP 6:You need to select the Base Item: (previous) and Base Field: Financial Year and press OK. STEP 5:Now you need to select the Show Values As tab and from the drop-down choose the Difference From STEP 4: Now click on the second Sales field’s (Sum of SALES2) drop down and choose Value Field Settings STEP 3: In the ROWS you have to put the Months field, in the COLUMNS the Years field and in the VALUES area the Sales field twice, I explain why below: STEP 2:In the Create PivotTable dialog box, Select Table range and then click on New Worksheet. ![]() ![]() ![]() STEP 1: Insert a Pivot Table by clicking on your data and going to Insert > Pivot Table
0 Comments
Leave a Reply. |