Got 2000 rows of data in a sheet and columns A to AJ, including columns holding "incoming document date" and "todays date". I've made a column AJ "Number of days from incoming to today", using formula: "DAYS360(O2;U2;TRUE)". Number of days in AJ is correct, and when I sort this column (AJ), it sorts correct highest to lowest number of days. Data table is formatted using standard choices in the Home Ribbon.
But I want to display this in a Dashboard, so I've made myself a pivot table, adding column AJ (number of days) into the "values"-box and document number (uniqe for each row) into the "row labels"-box. And by using the "Filter top 10-function", I'm trying to display top 10 cases (rows).
My problem is that the pivot table won't sort values correct from highest to lowest - and I can't figure out why.
Column AJ in my data table is formatted as "standard". In my pivot table I've tried both "sum" and "max" (same result).
All rows are uniqe, and pivot table holds rows (and values) that I can trace back to my data table. They just isn't sorted correcty...
Any ideas?
But I want to display this in a Dashboard, so I've made myself a pivot table, adding column AJ (number of days) into the "values"-box and document number (uniqe for each row) into the "row labels"-box. And by using the "Filter top 10-function", I'm trying to display top 10 cases (rows).
My problem is that the pivot table won't sort values correct from highest to lowest - and I can't figure out why.
Column AJ in my data table is formatted as "standard". In my pivot table I've tried both "sum" and "max" (same result).
All rows are uniqe, and pivot table holds rows (and values) that I can trace back to my data table. They just isn't sorted correcty...
Any ideas?
