15-Pivot Table

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 5

Values

Row Labels Sum of Turn Over (Crore) Sum of Repeat Business Sum of Employees
Custom Products 57.75 139 280
Fabrication 52.5 87 110
Garment Manufacturing 4.5 8 10
Grand Total 114.75 234 400
Create Pivot table

Monthly
Subscription
Name of Org. Business Employees Repeat Business Customers (INR)
Innospacer Custom Products 100 40 100 7000
Girimaji Fabrication 40 28 40 8000
Zenith Custom Products 50 35 50 10000
Unitech Fabrication 20 16 20 7000
Mollar Fabrication 20 16 20 7000
Mechano Fabrication 10 9 10 8000
Scotic Garment Manufacturing 10 8 10 7000
Growell Custom Products 30 24 30 7000
SIMCO Custom Products 100 40 100 7000
Sri Lakshmi Fabrication 20 18 20 6000
Turn Over (Crore) Turnover ('000) Profit
7.5 75000 3750
4.5 45000 4500
20 200000 30000
4.5 45000 4500
15 150000 15000
20 200000 50000
4.5 45000 4500
5.25 52500 2625
25 250000 25000
8.5 85000 8500
Category - multiple -

Data
Revenue StreamSum - Apr Sum - May Sum - Jun
Prdouct 391000 410100 420100
Total Result 391000 410100 420100
Revenue
Streams Category Apr May Jun Jul Aug Sep Oct
Prdouct Product A 201000 220100 220100 220200 220100 220100 220100
Prdouct Product B 190000 190000 200000 200100 200000 200100 200100
Prdouct Product C 350300 360000 300000 360000 360000 350000 355000
Prdouct Product D 120000 129000 129000 140000 140000 128000 140000
Services Consulting Services 200000 170000 200000 200000 200000 200000 200000
Services AMC Services 280000 260000 280000 270000 290000 280000 320000

Services Value Added Services 336000 385000 375000 399000 395000 410000 410000

You might also like