I am not sure if a pivot table is best for this... it would be good to see a sample report and what your expected output would be...

You may be able to use formulas for a solution....