This content has been marked as final. Show 2 replies
I would like to have the sum of the last day sales only, but I have a aggr error.
I have the folowing formula for the last day value:
if(max(total Date) = max(Date) and count(distinct Date)=1, [Sales(K$)],0)
with the following result:
|Date||Product||Sales||Last day sales|
The result expected is merely the sum of the last day sales, but it doesn't work:
sum(if(max(total Date) = max(Date) and count(distinct Date)=1, [Sales(K$)],0))
error: Nested aggregation not allowed
Could you please help?
Thanks in advance,