I have a data set that includes four columns; batch #, type, suit date and judgment date.
When creating a pivot table i have the batch # and type under row table and type under value to give me a count of each type by batch #. I add suit date to the values to get a count of suits of how many suits by type by batch #. I'd like to see the percentage between the two (count of type/count of suit date). How do i do that? I figure I need to create a calculated field, but don't know how it should be set up.
Any help?
Thanks
Bookmarks