i want to ask about the Date Ascending and descending order means
using Columns names in 1 parameter and ascending/descending options in 2nd parameter after that create a calculated field in which is like
Case [sort by column name]
if [sort order by]=" ascending" then Sum(MONTH(DATE("1 "+[Month]))*10000+YEAR(DATE("1 "+[Month])) ) else -Sum(MONTH(DATE("1 "+[Month]))*10000+YEAR(DATE("1 "+[Month]))) End
whereas descend as
any solutions as above not working not sort Month,day,year wise sorting on the Month,Day,Period of Calendar,
reply me @ firstname.lastname@example.org as well
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...