philfer
04-10-2010, 06:14 AM
Hello,
I have a pivottable where I am showing the "top 10" items.
Is there anyway to have an 11th item which simply says "other" which would then allow the total in the pivottable to agree to the total in the source table.
Thanks
Phil
I have a pivottable where I am showing the "top 10" items.
Is there anyway to have an 11th item which simply says "other" which would then allow the total in the pivottable to agree to the total in the source table.
Thanks
Phil