Hi,
I have attached my Excel file.
sheet "PIVOT TABLE." contains pivot table of entire data and sorted in Column L on descending order.
in sheet "PIVOT TABLE-TOP 5" I tried to Value filter top 5 records based on the values on column L.
But one record is not coming in top-5 even though it falls under top-5
That particular row is highlighted in yellow color sheet "PIVOT TABLE."
May know why that record is not coming? can any one help me on this?
Bookmarks