Another nasty issue I am not sure I can overcome...

I have base sales data. It includes multiple rows for every item on a sales order. Example (order Sales Order #, item, price, location)

11101, parta, 3.33, 200
11101, partb, 3.33, 200
11102, partd, 4.33, 100

I have created a pivot table that is summarizing some of the data, and one of the columns I would like to include is # of sales orders per location. With the above data I get location 200 having 2 sales orders if I use the count function; rather then 1.

I would prefer not to use subtotals in my raw data as I need the breakouts for other summarizing...is there any option within the pivot table to get the results I need?

Again, any assistance would be fabulous.

Sham