I have created an expense reports database where the user may enter the customer’s name when entertainment expenses are customer-related. I also have a hidden field where I create a text list of all customers entered (could possibly be 14 different customers). I can display this multi-valued field in a view, but I was asked to categorize the expenses by customer. Trying to categorize this field will list the customer but also all other customers in the list. Is there a way to list all expense reports related to each customer? In other words, have the same expense report listed multiple times but only displaying the expenses for that customer. They want to see how much money was spent on each customer for entertainment purposes.
Thank you for your help.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!