Scribd
Upload
5 views7 pages

Product Sales Data by Store

Uploaded by

Alexis Piette
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
5 views7 pages

Product Sales Data by Store

Uploaded by

Alexis Piette
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Data

Product Sum of StoreNorth Sum of StoreMiddle


A 918 653
B 619 805
C 1142 778
D 370 755
E 415 413
Total Result 3464 3404
Total of StoreNorth 3464 =GETPIVOTDATA("StoreNorth",$A$3)
Total of Product B in StoreNorth 619 =GETPIVOTDATA("StoreNorth",$A$3,"Product","B")
Sum of StoreSouth
1122
681
922
803
293
3821
ATA("StoreNorth",$A$3)
ATA("StoreNorth",$A$3,"Product","B")
Data
Date Record Sum of A Sum of B Sum of C Sum of D Sum of E
12/01/18 1.59 1.46 8.08 7.79 3.42
12/02/18 8.25 3.21 3.74 3.24 1.24
12/03/18 4.32 1.44 7.64 2.46 6.64
12/04/18 1.45 8.28 3.9 1.04 5.17
12/05/18 6.27 8.18 1.89 6.38 5.15
12/06/18 3.06 2.37 1.88 5.16 2.38
Total Result 24.94 24.94 27.13 26.07 24
12/3/2018
#REF! =GETPIVOTDATA("EachDate",A3,"Date Record",A12)
43437
Product StoreNorthStoreMiddlStoreSouth
A 180 192 381
B 301 307 298
C 295 127 322
A 260 104 281
C 489 385 490
D 176 276 319
A 478 357 460
C 358 266 110
D 194 479 484
E 415 413 293
B 116 297 275
B 202 201 108
Date Record
12/1/2018
12/2/2018
12/3/2018
12/4/2018
12/5/2018
12/6/2018
A B C D E
1.59 1.46 8.08 7.79 3.42
8.25 3.21 3.74 3.24 1.24
4.32 1.44 7.64 2.46 6.64
1.45 8.28 3.9 1.04 5.17
6.27 8.18 1.89 6.38 5.15
3.06 2.37 1.88 5.16 2.38

You might also like