Have you tried entering the "is prompted" into the filters of the second report for the columns that should be accepting the prompted values from the first report? I'm pretty sure that's what I've done.
I tried the solution mentioned regarding the concatenation of the month num with the name. Once you create the new column it still recognizes it as a text field and sorts it in text order - So you get Jan. (month 1) then Oct. (month 10).
There is a way though. Create a logical column with...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.