Moving rows to columns or columns to rows (or "pivoting") to see different summaries of the source data.įiltering, sorting, grouping, and conditionally formatting the most useful and interesting subset of data enabling you to focus on just the information you want.
Subtotaling and aggregating numeric data, summarizing data by categories and subcategories, and creating custom calculations and formulas.Įxpanding and collapsing levels of data to focus your results, and drilling down to details from the summary data for areas of interest to you. Querying large amounts of data in many user-friendly ways.
You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data. STEP 11: Click on the filter button in the chart and select 2012.A PivotTable is an interactive way to quickly summarize large amounts of data. The month to month comparison excel chart will appear in the worksheet. STEP 10: In the Insert Chart dialog box, select Column and click OK. STEP 9: To create a chart with this data, Go to PivotTable Analyze > PivotChart. From Previous Month or Monthly Variance.įrom in here, you can also click on the Number Format (bottom left-hand corner) to change the way the numbers show: STEP 8: You can do some cosmetic changes by going back into the Values Field Settings (from step 3) and changing the Custom Name to show whatever you like eg. So it will read the “ Difference from the previous Sales Month”
STEP 7:You need to select the Base Item as (previous) and Base Field as Sales Month and press OK. STEP 6: Now you need to select the Show Values As tab and from the drop-down choose the Difference From STEP 5: Now click on the second Sales field’s (Sum of SALES2) drop down and choose Value Field Settings STEP 4: In the ROWS section put in the Sales Month field, in the COLUMNS put in the Financial Year field and in the VALUES area you need to put in the Sales field twice, I explain why below:
0 kommentar(er)
