Ravi Sir's Cards › Excel
PivotTable layout: two values and a cross-tab
Revision card: PivotTable layout: two values and a cross-tab. Example data table with Count and Sum side by side: 3 and ₹220; Cross-tab by payment: ₹180 Online, ₹40 COD; A pivot that grows with data: Source: orders.
Read card text
What this card says
PivotTable layout: two values and a cross-tab
Example
data table with Count and Sum side by side: 3 and ₹220; Cross-tab by payment: ₹180 Online, ₹40 COD; A pivot that grows with data: Source: orders
Learn this in the lesson: Excel PivotTable with Multiple Values, Nested Rows and Columns: Count and Sum Side by Side, City by Payment Mode