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

Question & Answer
1

image

2

What type of calculation are you using? Some calculations don’t allow for totals. However you might be able to use a different calculation to do the same calculation and show a total.

3

Thanks for the response Max! yes we can achieve through a different calculation too…
I need to apply the below logic(Week Granularity),
if new_price < old_price then distinct_count(ABC) .

My result shouldn’t be a table calc.

I just need the distinct_count.

Tried writing calc but quicksight is throwing error.

Thanks

4

I think you have the same issue as this.