Update:

The actual problem is "Grand Total" is incorrect. This is true even when I do not select any dimension and just the sum of revenue.

However, when I slice it by any time dimension, the sliced data is correct except the grand total.

Looks like AS is ignoring some data. not sure what. The revenue column doenst have any null value though.