Formula help on counting a Text LI
Need help on how to count the number of times a Text dimension LI shows up under a List LI. We have tried to use the SUM function as well as LOOKUP function, but they did not work. For Ex) We would want to know how many "Merchant Id's" are under each individual 'Legal Milestone" Below are snap shots of the two line items and modules we are trying to complete this in.
The Formulas we have tried are below:
Merchant ID[SUM:Legal Milestone]
Merchant ID[LOOKUP:Legal Milestone]