Is there a way to have a pivot table not do a Total line if that only has one line but still shows the total line for section that have more than one line? It would be a cleaner look if only the line appeared.
I don't know of a way, but I have a pivot table where I want to do exactly what you want to do. In my case, most of the time there is only one entry, but I still need the breakdown plus a total if there is more than one. Hoping someone else has a solution!
