I have an excel sheet as given below. I want to name and address column in pivot table. If it is possible
Sheet1
<thead>
</thead><tbody>
</tbody>Excel 2007
Excel 2007
I want address column in pivot table column b. how can i do it in excel 2007
Sheet1
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | INVOIVCE NO | INVOICE DATE | CHELLAN NO | PARTY NAME | ADDRESS | ITEM NAME | ITEM CODE | HSN | QTY | TYPE |
| 2 | 5622218065 | 15/11/18 | Samsung | Mussaffa | TRIM CLIP ON LED PANEL 6W 6500K | LHEAABP7IL1W006 | 9405 | 24 | PURCHASE | |
| 3 | 18138811255 | Honeywell | Burdubai | TRIM CLIP ON LED PANEL 6W 6500K | LHEAABP7IL1W006 | 9405 | 1 | SALES RETURN | ||
| 4 | 5322121331 | 12/12/18 | CH.1723 | ABC TRADERS | Kalifa | TRIM CLIP ON LED PANEL 6W 6500K | LHEAABP7IL1W006 | 9405 | 1 | SALE |
| 5 | 4533588321 | Sun & Sand | Mrina | TRIM CLIP ON LED PANEL 6W 6500K | LHEAABP7IL1W006 | 9405 | 4 | SALE | ||
| 6 | 3365655881 | 21/12/18 | Maxwell | Port Sea | TRIM CLIP ON LED PANEL 6W 6500K | LHEAABP7IL1W006 | 9405 | 1 | SALE | |
| 7 | 1232558841 | Jumbo Traders | Khaldiya | TRIM CLIP ON LED PANEL 6W 6500K | LHEAABP7IL1W006 | 9405 | 1 | SALE | ||
| 8 | 3365458522 | 15/11/18 | Rotona | Sharja | TRIM CLIP ON LED PANEL 12W 6500K | LHEAABP7IL1W012 | 9405 | 24 | PURCHASE |
| Excel Workbook | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 3 | Sum of Field1 | Column Labels | |||||
| 4 | Row Labels | PURCHASE | SALE | SALES RETURN | Grand Total | ||
| 5 | ABC TRADERS | 0 | 1 | 0 | 1 | ||
| 6 | Honeywell | 0 | 0 | 1 | 1 | ||
| 7 | Jumbo Traders | 0 | 1 | 0 | 1 | ||
| 8 | Maxwell | 0 | 1 | 0 | 1 | ||
| 9 | Rotona | 24 | 0 | 0 | 24 | ||
| 10 | Samsung | 24 | 0 | 0 | 24 | ||
| 11 | Sun & Sand | 0 | 4 | 0 | 4 | ||
| 12 | Grand Total | 48 | 7 | 1 | 56 | ||
Sheet4 | |||||||
I want address column in pivot table column b. how can i do it in excel 2007
Last edited:
