Issue 1:
I calculated the running sum of distinct count, while the subtotal does not show any value for the total distinct count. The asin_aggregated (aggregated) is the running sum of distinct value.
Here is the calculations:
runningSum
(
distinct_count(asin),
[{inflow_week} ASC],
[{region_code},program,{country_code}]
)
Hi @fangfgao ,
welcome to the community 
I have the same issues when rebuilding it.
It works with runningSum(sum({measure}) but not with runningSum(distinct_count({measure}) .
Since there is no hint on the help page, this is an error for me.
Best regards,
Nico
Thank you for letting us know. I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!