Pivot Table in Excel - Grand Total & Sub Total

A pivot table is a statistics tool that summarizes and reorganizes selected columns and rows of data in a spreadsheet or database table to obtain a desired report. The tool does not actually change the spreadsheet or database itself, it simply “pivots” or turns the data to view it from different perspectives.
The Value Field Settings dialog box in a PivotTable allows users to change the calculation and display settings for data fields. The dialog box has two tabs: Summarize Values By and Show Values As.
The Summarize Values By tab has 11 calculation options, including Sum, Count, Average, Max, Min, Product, Count Numbers, StdDev, StdDevP, Var, and VarP. By default, numeric value fields use the Sum function, while text values use the Count function.
In a Microsoft Excel PivotTable, a subtotal is a sum of values in a row or column field. Subtotals and grand totals appear automatically when a PivotTable shows value amounts, but you can also hide or show them.
#custom #summarize #analyze #explore #present #calculation #Sum #Count #Average #Max #Min #Product #Count Numbers #StdDev #StdDevP #Var #VarP #numeric #fields #function #Show #Values #Grand #Grand Total #Column Total #Row Total #Running Total #Rank #Parent #Difference #subtotal #total #grand #grandtotal

[@manikandank7445]

Great video sir

[@kidoos6789]

Good explanation 👍