Counting like numbers as 1 in a pivot table

I have a scenario where I am trying to develop a more accurate KPI. We have a report that is returned as an excel spreadsheet. I am creating a KPI via a pivot table based on this spreadsheet.
I have 2 issues.

1) I am trying to count the number of loads. But the way this spreadsheet appears there is a row entry for every product. But, there is a posibility of multiple products for one delivery. The only constant is under ORDER# it is the same for each product in that order. If I could associate all the like order#'s as a value of one I would have the count.

2) Some of the loads are splits (we take one full load to 2 or more stores). I need to count splits but in the split column they place the word split for every different product and every different location. Meaning if I take 2 products to one store and 2 products to the other they will show it as 4 splits. In my terms it is only 1 split. Again the only constant data is the order#. Each product to each store will still have the same order#.

Capture.PNG

@vichopalacios
My apologies for not responding sooner. My email notifications were mistakenly off for this site and I thought no one had a solution as of yet and I was going to tweak the question.
The attached book you sent is close to what I am after. Simply put, each series of rows that you colored the same, represents a single load placed on a truck or 1 load.
Your counting works except in L5 and L6 where the value is 1 in each cell (counting as 2 loads even thought it should only be 1) as opposed to L2 and L3 where one cell is 0 and one cell is 1 or a total of 1 load.
Using your spread sheet maybe this will better show my end need. Thank you for your help.
*also know that the data does not need to be sorted by site only because we wont review this data or count this data by site. The main goal will be the number of loads and gallons hauled.

Which version of Excel are you using?

In Excel 2010 and later, if you add your Pivot Table to the Data Model as you create your PT that makes the Distinct Count available to you in your PT.

This means that you can right click your Splits and any other column in your PT:

Summarise Values by
Distinct Count (the last item)

I can send my version of your file if you need it.

Duncan