Hi
I have a piece of code which creates a Pivot table, then a button which runs some code to show only the Top 10 values.
This works fine until, the Pivot table has maybe 3 rows with values and up to 20 rows with no values.
In this case as there are not "10" to return the "Top 10", the Pivot returns too many rows... All 23...
Can I prevent this by adding some code which says "if there are not 10 Top items available show only the few rows that have a vlalue?
Thanks
Ronan
I have a piece of code which creates a Pivot table, then a button which runs some code to show only the Top 10 values.
This works fine until, the Pivot table has maybe 3 rows with values and up to 20 rows with no values.
In this case as there are not "10" to return the "Top 10", the Pivot returns too many rows... All 23...
Can I prevent this by adding some code which says "if there are not 10 Top items available show only the few rows that have a vlalue?
Thanks
Ronan
