1 Reply Latest reply on Jun 17, 2016 2:45 PM by diego.medrano

    Individual percentages and total counts

    Eric Freeman

      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?