Hi,
Is there an equivalent in Zoho (Aggregated Formula) to SQL’s
SUM() OVER (PARTITION BY ...)?
I’m looking for a way to calculate a sum within a group (partition) without collapsing the data, so that the result is still available at the row level.
Has anyone achieved similar behavior in Zoho Analytics? If so, what would be the recommended approach?
Thanks in advance!