Monday, 5 December 2016

PIVOT TABLE

PIVOT TABLE , PIVOT CHART
NAME product qty station
ali battery 89 mumbai
javed battery 74 mumbai
digmbar cpu 45 mumbai
lina ac 45 nashik
suchita battery 56 nashik
mona mouse 46 nashik
rohan battery 68 pune
pooja mouse 48 pune
prasad mouse 85 pune
hasina ac 35 thane
akbar cpu 54 thane
john cpu 125 thane
robin laptop 25 thane

FIND REPORT
sum stationwise report
sum product wise report
sum mumbai report
sum thane report
sum ac, mouse report
sum pune, battery repory
sum pooja,prasad,ali report
sum ali , javed,hasina report
count stationwise report
count product wise report

No comments:

Post a Comment