Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have a field 'Day Abbreviation' with values as - Mon,Tue,Wed,Thu,Fri,Sat,Sun which is been used as a dimension in a
Pivot table and in a Bar chart.
Custom sort is done using Match(Day Abbreviation,'Mon','Tue','Wed','Thu','Fri','Sat','Sun').The selections are done based on Customer names,Year(2014)and Quarter(Q2).
Custom sort is working fine based on the above selections but when a selection is changed on Quarter for eg; from Q2 to Q3,Custom sort is not working for some of the Customer names.
Have tried using Inline table for sorting,dual() function and enabling Load order on the 'Day Abbreviation' field,but couldn't resolve the sort issue.
Please suggest.
Thanks,
Neha
Hi
I would try
=Max({1} Match([Day Abbreviation], 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun'))
This will ignore any selections.
HTH
Jonathan
Hi,
If possible can share your sample apps.
Regards
Hi
I would try
=Max({1} Match([Day Abbreviation], 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun'))
This will ignore any selections.
HTH
Jonathan