Spreadsheet: 543084d1508234377-pivot-not-showing-data-when-data-is-present-pivot-not-showing-data-when-data-is-present-pivot-example
Sheet: NewData

Year | Supplier | Store | Month | Sales
2016 | [NAME] | a | Jan | 0
2016 | [NAME] | a | Feb | 0
2016 | [NAME] | a | Mar | 1188
2016 | [NAME] | a | Apr | 0
2016 | [NAME] | a | May | 893
2016 | [NAME] | a | Jun | 0
2016 | [NAME] | a | Jul | 0
2016 | [NAME] | b | Jan | 0
2016 | [NAME] | b | Feb | 0
2016 | [NAME] | b | Mar | 0
2016 | [NAME] | b | Apr | 0
2016 | [NAME] | b | May | 0
2016 | [NAME] | b | Jun | 512.5
2016 | [NAME] | b | Jul | 0
2016 | [NAME] | c | Jan | 75
2016 | [NAME] | c | Feb | 0
2016 | [NAME] | c | Mar | 0
2016 | [NAME] | c | Apr | 0
2016 | [NAME] | c | May | 863.73
2016 | [NAME] | c | Jun | 863.73
2016 | [NAME] | c | Jul | 0
2016 | [NAME] | d | Jan | 0
2016 | [NAME] | d | Feb | 0
2016 | [NAME] | d | Mar | 75
2016 | [NAME] | d | Apr | 0
2016 | [NAME] | d | May | 943.23
2016 | [NAME] | d | Jun | 726.73
2016 | [NAME] | d | Jul | 1159.73
2016 | [NAME] | e | Jan | 0
2016 | [NAME] | e | Feb | 0
2016 | [NAME] | e | Mar | 0
2016 | [NAME] | e | Apr | 0
2016 | [NAME] | e | May | 0
2016 | [NAME] | e | Jun | 0
2016 | [NAME] | e | Jul | 0
2016 | [NAME] | a | Jan | 7575
2016 | [NAME] | a | Feb | 0
2016 | [NAME] | a | Mar | 0
2016 | [NAME] | a | Apr | 0
2016 | [NAME] | a | May | 0
2016 | [NAME] | a | Jun | 649.5
2016 | [NAME] | a | Jul | 0
2016 | [NAME] | b | Jan | 0
2016 | [NAME] | b | Feb | 386
2016 | [NAME] | b | Mar | 0
2016 | [NAME] | b | Apr | 0
2016 | [NAME] | b | May | 0
2016 | [NAME] | b | Jun | 647.23
2016 | [NAME] | b | Jul | -214.23
2016 | [NAME] | c | Jan | 0
2016 | [NAME] | c | Feb | 0
2016 | [NAME] | c | Mar | 0
2016 | [NAME] | c | Apr | 4545
2016 | [NAME] | c | May | 0
2016 | [NAME] | c | Jun | 0
2016 | [NAME] | c | Jul | 433
2016 | [NAME] | d | Jan | 772
2016 | [NAME] | d | Feb | 0
2016 | [NAME] | d | Mar | 0
2016 | [NAME] | d | Apr | 0
2016 | [NAME] | d | May | 647.23
2016 | [NAME] | d | Jun | 0
2016 | [NAME] | d | Jul | 945.5
2016 | [NAME] | e | Jan | 0
2016 | [NAME] | e | Feb | 0
2016 | [NAME] | e | Mar | 0
2016 | [NAME] | e | Apr | 0
2016 | [NAME] | e | May | 0
2016 | [NAME] | e | Jun | 1263.5
2016 | [NAME] | e | Jul | 808.5
2016 | [NAME] | f | Jan | 0
2016 | [NAME] | f | Feb | 5485
2016 | [NAME] | f | Mar | 0
2016 | [NAME] | f | Apr | 0
2016 | [NAME] | f | May | 0
2016 | [NAME] | f | Jun | 863.73
2016 | [NAME] | f | Jul | 0
2016 | [NAME] | a | Jan | 0
2016 | [NAME] | a | Feb | 0
2016 | [NAME] | a | Mar | 0
2016 | [NAME] | a | Apr | 45
2016 | [NAME] | a | May | 0
2016 | [NAME] | a | Jun | 0
2016 | [NAME] | a | Jul | 0
2016 | [NAME] | b | Jan | 0
2016 | [NAME] | b | Feb | 0
2016 | [NAME] | b | Mar | 7575
2016 | [NAME] | b | Apr | 0
2016 | [NAME] | b | May | 0
2016 | [NAME] | b | Jun | 0
2016 | [NAME] | b | Jul | 0
2016 | [NAME] | c | Jan | 4324
2016 | [NAME] | c | Feb | 5
2016 | [NAME] | c | Mar | 0
2016 | [NAME] | c | Apr | 0
2016 | [NAME] | c | May | 293.73
2016 | [NAME] | c | Jun | -293.73
2016 | [NAME] | c | Jul | 0
2016 | [NAME] | d | Jan | 0
2016 | [NAME] | d | Feb | 0
2016 | [NAME] | d | Mar | 75
2016 | [NAME] | d | Apr | 868
2016 | [NAME] | d | May | 0
2016 | [NAME] | d | Jun | 0
2016 | [NAME] | d | Jul | 1515.5
2017 | bill | a | Jan | 0
2017 | bill | a | Feb | 74
2017 | bill | a | Mar | 0
2017 | bill | a | Apr | 0
2017 | bill | a | May | 0
2017 | bill | a | Jun | 0
2017 | bill | a | Jul | 159
2017 | bill | b | Jan | 0
2017 | bill | b | Feb | 0
2017 | bill | b | Mar | 0
2017 | bill | b | Apr | 0
2017 | bill | b | May | 0
2017 | bill | b | Jun | 0
2017 | bill | b | Jul | 729
2017 | bill | c | Jan | 0
2017 | bill | c | Feb | 0
2017 | bill | c | Mar | 0
2017 | bill | c | Apr | 0
2017 | bill | c | May | 0
2017 | bill | c | Jun | 649.5
2017 | bill | c | Jul | 0
2017 | bill | d | Jan | 0
2017 | bill | d | Feb | 0
2017 | bill | d | Mar | 52445
2017 | bill | d | Apr | 56896
2017 | bill | d | May | 0
2017 | bill | d | Jun | 0
2017 | bill | d | Jul | 866
2017 | [NAME] | a | Jan | 45
2017 | [NAME] | a | Feb | 0
2017 | [NAME] | a | Mar | 0
2017 | [NAME] | a | Apr | 0
2017 | [NAME] | a | May | 0
2017 | [NAME] | a | Jun | 0
2017 | [NAME] | a | Jul | 0
2017 | [NAME] | b | Jan | 0
2017 | [NAME] | b | Feb | 0
2017 | [NAME] | b | Mar | 0
2017 | [NAME] | b | Apr | 0
2017 | [NAME] | b | May | 0
2017 | [NAME] | b | Jun | 433
2017 | [NAME] | b | Jul | 216.5
2017 | [NAME] | c | Jan | 0
2017 | [NAME] | c | Feb | 545
2017 | [NAME] | c | Mar | 0
2017 | [NAME] | c | Apr | 0
2017 | [NAME] | c | May | 0
2017 | [NAME] | c | Jun | 0
2017 | [NAME] | c | Jul | 0
2017 | [NAME] | d | Jan | 4242
2017 | [NAME] | d | Feb | 0
2017 | [NAME] | d | Mar | 0
2017 | [NAME] | d | Apr | 7575
2017 | [NAME] | d | May | 866
2017 | [NAME] | d | Jun | 0
2017 | [NAME] | d | Jul | 0
2017 | [NAME] | e | Jan | 0
2017 | [NAME] | e | Feb | 0
2017 | [NAME] | e | Mar | 0
2017 | [NAME] | e | Apr | 0
2017 | [NAME] | e | May | 433
2017 | [NAME] | e | Jun | 649.5
2017 | [NAME] | e | Jul | 0
2017 | [NAME] | a | Jan | 0
2017 | [NAME] | a | Feb | 0
2017 | [NAME] | a | Mar | 0
2017 | [NAME] | a | Apr | 0
2017 | [NAME] | a | May | 0
2017 | [NAME] | a | Jun | 0
2017 | [NAME] | a | Jul | 433
2017 | [NAME] | b | Jan | 0
2017 | [NAME] | b | Feb | 0
2017 | [NAME] | b | Mar | 0
2017 | [NAME] | b | Apr | 0
2017 | [NAME] | b | May | 0
2017 | [NAME] | b | Jun | 0
2017 | [NAME] | b | Jul | 0
2017 | [NAME] | c | Jan | 45
2017 | [NAME] | c | Feb | 47527
2017 | [NAME] | c | Mar | 757
2017 | [NAME] | c | Apr | 6
2017 | [NAME] | c | May | 0
2017 | [NAME] | c | Jun | 0
2017 | [NAME] | c | Jul | 0
2017 | [NAME] | d | Jan | 0
2017 | [NAME] | d | Feb | 0
2017 | [NAME] | d | Mar | 0
2017 | [NAME] | d | Apr | 0
2017 | [NAME] | d | May | 0
2017 | [NAME] | d | Jun | 0
2017 | [NAME] | d | Jul | 0
2017 | [NAME] | a | Jan | 0
2017 | [NAME] | a | Feb | 0
2017 | [NAME] | a | Mar | 0
2017 | [NAME] | a | Apr | 0
2017 | [NAME] | a | May | 159
2017 | [NAME] | a | Jun | 0
2017 | [NAME] | a | Jul | 216.5
2017 | [NAME] | b | Jan | 0
2017 | [NAME] | b | Feb | 45
2017 | [NAME] | b | Mar | 0
2017 | [NAME] | b | Apr | 45
2017 | [NAME] | b | May | 0
2017 | [NAME] | b | Jun | 0
2017 | [NAME] | b | Jul | 649.5
2017 | [NAME] | c | Jan | 0
2017 | [NAME] | c | Feb | 0
2017 | [NAME] | c | Mar | 0
2017 | [NAME] | c | Apr | 0
2017 | [NAME] | c | May | 0
2017 | [NAME] | c | Jun | 428.46
2017 | [NAME] | c | Jul | 0
2017 | [NAME] | d | Jan | 0
2017 | [NAME] | d | Feb | 0
2017 | [NAME] | d | Mar | 0
2017 | [NAME] | d | Apr | 0
2017 | [NAME] | d | May | 0
2017 | [NAME] | d | Jun | 0
2017 | [NAME] | d | Jul | 0
2017 | [NAME] | e | Jan | 455
2017 | [NAME] | e | Feb | 4545
2017 | [NAME] | e | Mar | 0
2017 | [NAME] | e | Apr | 6886
2017 | [NAME] | e | May | 0
2017 | [NAME] | e | Jun | 0
2017 | [NAME] | e | Jul | 0
2017 | [NAME] | f | Jan | 0
2017 | [NAME] | f | Feb | 0
2017 | [NAME] | f | Mar | 0
2017 | [NAME] | f | Apr | 688
2017 | [NAME] | f | May | 433
2017 | [NAME] | f | Jun | 0
2017 | [NAME] | f | Jul | 0