Is there any other way to display the totals as the show total option is not displaying any value for the custom field

[Max]

I think you have the same issue as this.

Need to take the distinct count of product without using table calc

Hi, Can someone help me write the below calculation? (it has to be in week granularity) if new_price < old_price then distinct_count(product) I have tried writing this calc but quicksight is throwing an error, distinctCountOver ( ifelse({new_price<old_price}=1,distinct_count(product),NULL), [truncDate(‘WK’,{date})],PRE_FILTER ) Thanks