I have inventory data, and I want to see what percentage is early, ontime, and late. I also want to know how many items were delivered.
I saw a suggestion to make 5 calculated fields, which does work. But I stumbled upon something easier.
1. Add Inventory twice (once as percentage, once as count).
2. Change formatting to put the numbers on the same line.
3. Put a ; or _ in the custom formatting to hide the percentage from the total and the count from the other rows.
This works, but feels kludgy. Is there a better way or am I using the custom format feature correctly?
As far as I can tell, you're using the feature correctly. Is there a specific way you'd like to change the behavior?
If you provide us with a packaged workbook we might be able to take a closer look.