I have a pivot table with a large amount of data in it (70 columns along the top with (for example) a car name and 10 rows deep with say a city), however a large amount of the data (which is the sum of the dollar amount of that certain car sales in that city) is immaterial.
Is there any way to be able to filter out the dollar amounts that are less than say 1,000?
thanks
Is there any way to be able to filter out the dollar amounts that are less than say 1,000?
thanks