Hi Guys,
I have a sample data set that shows costs incurred by type of vehicle. I've created a pivot and within that, a calculated field. The field takes the cost/count of vehicle type and it's returning a Div/0. The end goal is to see the cost per individual vehicle within that type.
I created a sample and uploaded, although here's an example.
My class A vehicles incurred $50K in breakdowns. There were a total of 4 vehicles which amounts to an average of $12,500 for class A vehicles.
Does anyone have an idea on this?
Bookmarks