I'm currently generate daily, monthly reports base from Line Items table.
It working fine, however, it's too much work because I had to created many fields like SubSummary, SumSummary (Running), etc..
My reports are complex b/c it base on the commission. Commission % is base on the service type/product type.
I need some suggestions.
I want to have options that the managers can view the reports such as 60%-40%, 50%-50%, 55%-45%.
Is there a way I can write a script to generate such reports ?
60% of Service A
20% of Product A
40% of Service A
80% of Product A