Pivot Tables Andriuha - 26 32 58 3 Sum of Sales 237 308 545...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Pivot Tables by Alba Shehu 12/14/2009 Region Divison Data North South Grand Total 1 Sum of Sales 1002 997 1999 Sum of Profit 200 150 350 2 Sum of Sales 98 34 132 Sum of Profit 23 3 26 3 Sum of Sales 234 3 237 Sum of Profit 70 0 70 4 Sum of Sales 456 456 Sum of Profit 50 50 Total Sum of Sales 1334 1490 2824 Total Sum of Profit 293 203 496
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Pivot Table by Alba Shehu 12/14/2009 Divison Region 1 1 Total 2 2 Total 3 3 Total 4 4 Total Grand Total Data North South North South North South South Sum of Sales 1002 997 1999 98 34 132 234 3 237 456 456 2824 Sum of Profit 200 150 350 23 3 26 70 0 70 50 50 496
Background image of page 2
Pivot Tables by Alba Shehu 12/14/2009 Region (All) Year Divison Data 1998 1999 Grand Total 1 Sum of Sales 1999 2199 4198 Sum of Profit 350 385 735 2 Sum of Sales 132 159 291 Sum of Profit
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 26 32 58 3 Sum of Sales 237 308 545 Sum of Profit 70 91 161 4 Sum of Sales 456 638 1094 Sum of Profit 50 70 120 Total Sum of Sales 2824 3304 6128 Total Sum of Profit 496 578 1074 Sale Data by Region and Devision Region Divison Sales Profit Year North 1 $1,002 $200 1998 North 2 $98 $23 1998 North 3 $234 $70 1998 South 1 $997 $150 1998 South 2 $34 $3 1998 South 3 $3 $0 1998 South 4 $456 $50 1998 North 1 $1,102 $220 1999 North 2 $118 $28 1999 North 3 $304 $91 1999 South 1 $1,097 $165 1999 South 2 $41 $4 1999 South 3 $4 $0 1999 South 4 $638 $70 1999...
View Full Document

Page1 / 4

Pivot Tables Andriuha - 26 32 58 3 Sum of Sales 237 308 545...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online