I try to make same thing from your sheet but it is not working in mine.
You did below things right?
Created set on BL Number without null
sorted according to Month-Year, with null being last.
correct pls. if wrong.
I did same thing in my sheet but it is not working. Actually Month-year and year is BL date column which i want to show before Month-Year and year column.
Also may be i was wrong attaching wrong data in excel.due to size i cut paste only few rows from original excel output.
Attaching again all correct data and my tableau sheet.
1 of 1 people found this helpful
Plz find the attached workbook. i just modified the same workbook you tried. You have to use the sets you created in the column shelf if you want to see the sets. in the previous attachment i sent i used the sets in the column shelf. its just that i unchecked the 'show header' option for the set created. that,s why you couldn't see it in the column shelf.
But it is not necessary to create a set as such. you can do it even without it.
I have attached two workbooks. one with set, and other without set.
And only thing is the year or month columns have to be in the first column.
I tried Today. I was able to do it with manual Sort on BL date(Month-Year format) putting it first same like your solution. But was not happy with the solution.
Actually Important here was Format. User want excel output in his Format.
Anyway i'll tell user to just delete the First column from output when he takes Excel output.
Sorry i couldn't respond immediately.
Any ways, if u r particular about the position of the columns, create duplicates of the year dimensions and place them in needed place.
Plz find the attachment, i placed the year and months(duplicates) at the end as u want.
I still used the original once in the staring places to help me in sorting. but you will not be able to see them in the report as i deselected the 'show header' option for the first four pills in the rows shelf.
check the attachment. u can as well adjust the columns as needed, without touching the first four columns.
Book1_Nulls Last_no Sets.twbx 180.2 KB