Is there any other way to display the totals as the show total option is not displaying any value for the custom field
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.
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.
I think you have the same issue as this.