Hi
I have a field called department, on that field i have multiple values like
department=Production for Medicine
department=Research and Development
department=Purchasing
department=Marketing
department=Human Resource Management
department=Accounting and Finance
department=Production for Medicine-PFM
department=Research and Development-RD
So after running stats count by department am getting below results like
department count
Production for Medicine 5
Research and Development 10
Purchasing 12
Marketing 6
Human Resource Management 3
Accounting and Finance 4
Production for Medicine-PFM 6
Research and Development-RD 13
What I need is to add count value of following:
Production for Medicine + Production for Medicine-PFM =11
Research and Development + Research and Development-RD =23
Kindly let me know if there is any solution to get above result.
... View more