
1. Re: Mismatch between Running_Total and Grand Total
Stoyko Kostov Aug 15, 2016 3:44 PM (in response to madhuri.tanniru)1 of 1 people found this helpfulHi Madhuri,
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 crosscheck my statement in the following way: create a new sheet, drag Year(Order Date) to Columns, and Value to Text. Rightclick 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.

2. Re: Mismatch between Running_Total and Grand Total
madhuri.tanniru Aug 15, 2016 9:09 PM (in response to Stoyko Kostov)Thanks a lot Stoyko!
Thanks,
Madhuri