Hi

We have created an application in Zoho where we have sales invoices and for every sales invoice, we have employee contributions captured. So, there are 2 tables in Zoho Creator. One table for the invoice with the a field for the associated employee who is responsible for the revenue contribution of that invoice. In the employee table, we have managers for every employee which basically is a lookup field to the same table. And the hierarchy is multi level where there are managers for managers and so on. Now, we would like to roll up the contribution from the employee to manager and super manager and so on. The data from creator is in Analytics and I would like to write an sql query to roll up the data so that we can get the total contribution at every manager level as a sum of the contributions of the employees under them. A simple summing query with group by will not work as the data needs to be summed up at every level. Could anyone let me know how we can write this query in Analytics?

Regards

Mani.