Spreadsheet: 121919d1316509340-omiting-data-from-pivot-charts-but-displaying-in-pivot-table-792439
Sheet: Sheet1

Product | Profit
A | 3
A | 114 |  |  |  |  |  | Row Labels | Count of Product | Sum of Profit | Sum of Profit2
A | 59 |  |  |  |  |  | A | 241 | 16865 | 0.2187958121975584
D | 43 |  |  |  |  |  | B | 301 | 22044 | 0.2859848730556168
A | 111 |  |  |  |  |  | C | 270 | 18986 | 0.2463123208053865
D | 117 |  |  |  |  |  | D | 252 | 19186 | 0.2489069939414382
D | 91 |  |  |  |  |  | Grand Total | 1064 | 77081 | 1
A | 36
D | 68
B | 27
D | 89
A | 60
B | 84
C | 36
B | 89
C | 82
C | 78
A | 67
B | 47
C | 91
A | 108
C | 28
D | 67
C | 99
A | 32
D | 81
C | 60
C | 100 |  |  |  |  | Row Labels | Sum of Profit | Sum of Profit2
C | 87 |  |  |  |  | A | 16865 | 0.2187958121975584
D | 103 |  |  |  |  | B | 22044 | 0.2859848730556168
D | 116 |  |  |  |  | C | 18986 | 0.2463123208053865
B | 44 |  |  |  |  | D | 19186 | 0.2489069939414382
C | 95 |  |  |  |  | Grand Total | 77081 | 1
B | 71
C | 73
C | 49
C | 118
A | 42
A | 115
A | 44
A | 51
D | 113
A | 65
A | 53
A | 45
B | 80
B | 29
A | 114
B | 109
B | 49
C | 57
B | 103
D | 47
C | 87
A | 105
D | 34
D | 96
B | 116
B | 66
D | 100
B | 116
D | 89
A | 41
B | 41
D | 97
A | 73
D | 99
B | 58
D | 82
C | 63
D | 61
A | 112
C | 62
C | 82
D | 75
D | 120
C | 88
D | 104
D | 75
B | 86
B | 41
B | 48
D | 108
B | 99
C | 37
C | 69
B | 107
D | 54
B | 117
A | 33
D | 33
D | 58
D | 102
C | 85
C | 64
B | 119
C | 87
B | 119
D | 33
A | 58
A | 90
B | 56
A | 87
B | 70
C | 39
C | 63
D | 81
A | 38
D | 103
C | 73
B | 97
A | 65
D | 50
D | 108
A | 42
B | 31
C | 101
B | 39
D | 38
D | 57
A | 89
D | 39
B | 118
C | 90
C | 44
A | 98
D | 73
D | 73
C | 95
A | 63
D | 90
B | 103
B | 101
C | 54
C | 84
C | 29
B | 85
A | 86
D | 90
C | 76
D | 119
B | 84
D | 107
C | 120
B | 73
B | 85
C | 107
A | 37
A | 49
A | 66
B | 111
B | 41
B | 33
A | 76
A | 89
D | 50
D | 109
B | 64
B | 75
A | 54
C | 119
D | 43
C | 72
A | 63
D | 33
B | 36
D | 85
B | 89
D | 103
C | 112
B | 48
D | 84
B | 84
A | 29
B | 92
B | 80
B | 98
C | 26
A | 99
B | 82
C | 73
C | 40
D | 84
C | 65
C | 80
C | 84
C | 34
A | 105
C | 86
A | 32
C | 37
C | 89
C | 35
B | 33
C | 91
C | 77
D | 98
A | 86
D | 105
B | 107
D | 33
B | 45
D | 95
D | 83
A | 27
D | 63
B | 87
A | 91
A | 113
C | 109
D | 94
D | 69
C | 54
D | 59
A | 55
A | 61
C | 34
C | 79
B | 94
B | 26
A | 70
B | 36
C | 114
A | 83
D | 93
A | 94
A | 45
A | 27
B | 101
D | 111
B | 102
D | 75
A | 86
C | 118
C | 57
B | 106
A | 52
A | 44
A | 55
B | 97
A | 42
C | 27
A | 33
B | 58
A | 63
B | 53
D | 48
D | 97
B | 96
D | 114
A | 120
C | 45
A | 56
A | 25
A | 81
B | 100
B | 93
D | 80
B | 46
A | 27
A | 73
A | 31
B | 75
D | 83
B | 80
C | 45
C | 47
B | 76
D | 59
B | 103
D | 112
A | 60
C | 75
D | 68
D | 101
D | 28
B | 31
D | 25
C | 91
C | 59
A | 44
C | 104
A | 95
A | 85
C | 76
B | 29
D | 57
A | 32
B | 35
A | 33
A | 114
D | 64
B | 94
D | 91
A | 59
D | 81
B | 31
B | 63
B | 33
A | 94
A | 48
A | 64
C | 89
A | 85
B | 118
C | 103
A | 118
B | 56
C | 45
A | 43
B | 55
D | 119
C | 110
C | 69
B | 73
D | 66
D | 33
B | 35
C | 40
B | 112
A | 56
C | 63
C | 62
D | 83
B | 90
D | 98
C | 72
B | 88
B | 65
B | 36
A | 53
A | 105
B | 82
C | 111
C | 106
D | 30
C | 28
C | 58
D | 106
A | 25
D | 36
B | 49
B | 34
B | 40
A | 70
C | 37
A | 90
B | 44
A | 93
B | 56
B | 76
B | 95
B | 78
C | 76
D | 60
A | 108
A | 32
C | 93
D | 27
C | 55
C | 110
D | 120
B | 25
D | 50
A | 32
C | 66
A | 67
A | 55
B | 106
A | 47
D | 114
B | 78
A | 58
C | 39
D | 112
A | 103
A | 80
C | 27
D | 108
B | 80
D | 114
C | 32
B | 25
B | 65
D | 108
D | 105
D | 90
C | 117
A | 43
B | 69
B | 85
D | 34
D | 69
D | 89
B | 50
C | 63
C | 88
D | 112
D | 115
D | 73
B | 33
B | 115
A | 72
C | 50
D | 106
B | 63
B | 39
D | 84
D | 115
C | 78
C | 114
D | 118
D | 85
B | 51
D | 49
B | 97
C | 96
D | 25
C | 38
D | 88
B | 54
C | 72
D | 27
B | 50
D | 118
D | 71
C | 36
D | 25
B | 118
C | 38
A | 102
C | 56
D | 69
B | 38
C | 87
B | 101
A | 43
C | 96
A | 83
C | 117
D | 105
D | 53
D | 90
A | 58
D | 31
D | 43
A | 81
A | 100
C | 92
C | 26
B | 65
D | 52
A | 84
D | 30
C | 75
C | 91
C | 43
C | 79
C | 33
A | 110
D | 28
A | 116
D | 105
D | 77
A | 110
A | 66
B | 87
B | 56
A | 47
B | 92
C | 61
D | 38
A | 112
D | 86
D | 71
A | 62
A | 29
B | 27
C | 113
D | 99
D | 112
C | 59
A | 68
B | 38
C | 114
D | 72
C | 38
B | 115
A | 73
B | 59
C | 98
B | 73
C | 73
C | 89
D | 32
B | 102
B | 96
B | 81
A | 108
C | 92
A | 26
D | 45
B | 46
A | 82
C | 33
B | 101
A | 79
A | 25
D | 61
A | 67
D | 36
D | 65
B | 69
D | 113
C | 46
B | 34
B | 94
C | 39
B | 116
C | 64
B | 61
B | 118
A | 66
B | 31
B | 54
A | 103
A | 58
D | 52
C | 25
D | 90
A | 66
D | 97
B | 105
B | 107
C | 75
C | 80
B | 74
B | 109
C | 31
B | 120
C | 37
C | 97
B | 106
C | 93
C | 114
B | 109
B | 38
B | 33
C | 33
A | 27
A | 30
B | 57
A | 61
A | 31
B | 116
B | 30
C | 68
A | 99
C | 77
B | 61
A | 51
A | 66
A | 57
D | 71
D | 91
B | 112
C | 48
B | 113
B | 27
C | 94
B | 83
C | 120
D | 109
B | 47
A | 38
C | 56
D | 39
A | 62
A | 114
C | 99
B | 80
B | 26
D | 120
C | 27
D | 51
C | 34
C | 113
A | 78
C | 111
C | 99
B | 98
B | 86
B | 107
C | 63
B | 98
C | 29
A | 65
B | 80
D | 60
A | 108
A | 102
A | 79
D | 67
D | 92
A | 76
D | 37
B | 65
C | 43
C | 52
D | 119
B | 32
C | 55
C | 52
D | 108
C | 75
D | 83
D | 113
C | 88
A | 98
B | 97
B | 67
C | 38
D | 98
A | 40
D | 62
C | 114
D | 112
C | 28
C | 97
B | 86
A | 25
B | 27
C | 30
A | 29
D | 37
A | 38
D | 61
C | 71
D | 59
C | 75
D | 61
D | 105
D | 119
B | 57
B | 118
D | 120
A | 116
B | 37
B | 96
A | 81
D | 109
C | 63
B | 62
B | 104
C | 48
C | 40
C | 55
A | 30
A | 91
D | 98
D | 80
A | 33
A | 66
A | 55
B | 111
D | 58
A | 45
B | 40
B | 116
C | 46
A | 119
D | 50
A | 87
B | 33
D | 70
B | 116
A | 71
D | 86
B | 72
D | 77
B | 74
D | 120
C | 103
D | 26
B | 59
B | 79
A | 77
D | 41
A | 45
C | 97
D | 59
A | 70
B | 46
A | 62
C | 61
C | 60
B | 43
B | 31
B | 110
D | 57
C | 62
B | 44
C | 86
A | 80
B | 92
A | 39
B | 40
C | 27
A | 83
A | 118
C | 45
D | 118
B | 89
D | 84
C | 85
C | 77
D | 94
D | 69
D | 42
D | 76
C | 86
C | 36
B | 105
B | 119
B | 85
A | 62
A | 47
A | 118
D | 36
B | 99
D | 89
D | 58
B | 37
D | 28
C | 48
A | 64
C | 30
B | 40
C | 94
D | 69
B | 90
C | 78
B | 73
C | 56
B | 87
B | 101
B | 44
B | 68
A | 68
A | 117
C | 42
D | 47
A | 70
B | 111
B | 69
D | 91
B | 107
D | 115
B | 99
D | 106
D | 105
D | 58
B | 59
D | 111
A | 57
A | 32
C | 70
C | 65
B | 53
A | 30
A | 28
B | 96
C | 44
A | 108
B | 62
D | 61
C | 81
C | 77
B | 77
B | 100
A | 88
C | 110
A | 58
C | 71
C | 91
B | 97
C | 82
D | 75
D | 117
B | 82
D | 89
D | 39
B | 80
B | 115
A | 54
D | 61
D | 43
D | 53
B | 120
A | 77
B | 115
A | 58
A | 107
A | 87
A | 112
D | 35
D | 63
B | 61
B | 89
C | 69
C | 111
A | 118
A | 57
B | 79
D | 59
D | 98
B | 115
D | 89
C | 93
C | 111
B | 49
B | 94
B | 120
D | 80
B | 33
D | 78
D | 27
C | 83
C | 64
A | 48
B | 83
D | 37
C | 41
C | 117
A | 75
D | 88
C | 27
B | 83
A | 106
A | 69
B | 98
A | 66
B | 51
C | 47
C | 76
C | 75
C | 68
D | 30
C | 61
D | 83
C | 119
B | 66
A | 109
C | 49
C | 103
B | 34
B | 72
C | 54
B | 59
C | 50
C | 101
B | 94
D | 46
B | 41
B | 74
D | 33
B | 53
B | 57
A | 83
C | 77
B | 120
C | 74
A | 61
A | 43
B | 33
C | 39
D | 96
C | 86
B | 69
B | 114
A | 97
B | 85
C | 84
D | 66
A | 81
A | 63
C | 28
B | 43
C | 76
B | 56
B | 95
B | 109
B | 96
D | 36
A | 55
B | 28
D | 91
C | 46
A | 62
B | 97
D | 46
C | 25
C | 58
B | 41
D | 71
B | 85
B | 89
B | 94
A | 118
B | 39
B | 51
B | 42
B | 71
D | 98
C | 58
B | 98
A | 102
A | 63
A | 81
C | 111
B | 54
C | 108
D | 64
D | 78
D | 116
B | 76
B | 74
A | 63
A | 96
C | 68
C | 34
A | 42
C | 87
B | 49
B | 58
D | 118
B | 25
B | 48
C | 50
C | 73
A | 85
B | 75
A | 88
A | 91
D | 49
A | 112
D | 81
B | 29
D | 28
C | 46
D | 66
B | 119
C | 82
C | 107
B | 78
D | 64
A | 119
A | 47
B | 44
A | 103
B | 119
D | 98
A | 91
C | 65
A | 42
A | 63
D | 37
D | 75
C | 28
C | 49
C | 72
B | 97
C | 59
C | 91
D | 103
C | 52
D | 75
B | 119
B | 89
C | 37
B | 81
D | 119
C | 64
A | 35
C | 41
D | 113
B | 79
C | 56
A | 30
C | 80
C | 83
C | 82
A | 111
B | 54
C | 111
C | 69
B | 46
B | 76
B | 53
C | 86
D | 67
B | 49
D | 72
A | 59
C | 82
C | 97
B | 117
A | 81
D | 55
B | 60
D | 80
B | 32
A | 43
D | 106
B | 38
C | 34
A | 55
B | 53
A | 72
A | 99
B | 38
A | 114
A | 56
A | 112
C | 68
B | 111
D | 45
B | 92
C | 75
C | 71
C | 83
C | 60
D | 81
B | 49
A | 111
A | 113
C | 117
B | 38
C | 47
C | 44
A | 55
C | 78
C | 101
A | 81
B | 44
C | 109
D | 80
C | 119
C | 71
A | 45
D | 56
A | 56
C | 67
A | 86
D | 77
C | 44
D | 99
A | 43
B | 92
B | 62
B | 48
B | 97
B | 58
D | 81