1 of 1 people found this helpful
The Grand Total in the "Distinct Count of Value" columns is NOT the sum of the "distinct count of value" for each day. It is simply the count of distinct values for the entire year.
The Running Total is the actual sum.
The definitions are different: for example, if you have Day 1 with distinct values A, B, C, and Day 2 with distinct values C, D, E, the overall distinct values are 5 - A through E, but the sum of the daily distinct values is 6 (3+3).
The numbers coincide for 2016 by chance.
You can cross-check my statement in the following way: create a new sheet, drag Year(Order Date) to Columns, and Value to Text. Right-click on the pill and choose COUNT DISTINCT as aggregation. You'll see 253 distinct values for 2015 and 263 for 2016, which are the same values you've highlighted above.
In general, COUNTD is not a good aggregation to compute totals on, as it is not additive - explained in the example I gave above.
Let me know if you have any questions.
Thanks a lot Stoyko!