Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have a pivot table which has a dimension of "Month" in the format of "Jan 2014." I have it set to sort numerically, but the drop down selection on the pivot table is not sorting. How would I be able to get this list sorted properly?
In the screen shot, the red box shows the drop down values that are not sorted correctly. The blue box shows the rows in the pivot table that are sorted correctly. I would like to sort the drop down values the same as the row values.
I solved my issue. I loaded the data using the dual() function.
dual(month, monthyear)
where "month" is in the format of "Jan 2015"
and "monthyear" is in the format of 201501
I suspect your "Month" field is stored in Text format and not Numeric.
Wouldn't that be affected everywhere and not just in the drop down?
Quite likely - hard for me to see "everywhere" without the qvf.
I solved my issue. I loaded the data using the dual() function.
dual(month, monthyear)
where "month" is in the format of "Jan 2015"
and "monthyear" is in the format of 201501