Hi,
I have to calculate the visit average for each month and for each category of clients.
For the first subset (visit average by month) i can use the BY function (eg average formula BY Fiscal Month), but I don't know how to divide that month subset further and obtain its subsets by category of clients.
How could I add two BY functions to my average formula?
Any help would be greatly appreciated.
Thank you in advance,
Francis