Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys, How could I sort a pivot table of an specific order, I attached a pic and the app with 2 pivote tables, I need to sort the below table like the one above, I tryed but it has a "+" and this ´sign doesn´t let me to sort like the table above, any idea??
Thank you Guys!!
Hi,
Use sort expression as =MixMatch(Clasificador_Dias_Condicion,'Current','30 Days','60 Days','90 Days','120 Days','+120 Days') instead of ColumnNo() and set sort by ascending.
Celambarasan
Edit: Check the attached app
Hi,
Use sort expression as =MixMatch(Clasificador_Dias_Condicion,'Current','30 Days','60 Days','90 Days','120 Days','+120 Days') instead of ColumnNo() and set sort by ascending.
Celambarasan
Edit: Check the attached app
Excelent, thank you celambarasan !!!