Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way in a pivot table to sort my delivery ID's in order?
Like This below
3AM
8AM
1PM
3PM
May be using Match function
Match(DelivID, '3AM', '8AM', '1PM', '3PM', .....)
This is what I got
by adding this
match(DelivID,'3AM','8AM','1PM','3PM','5PM-WK','8PM','11PM','OUTS','STAT',' ')
I think you did it as a calculated dimension, why don't you try this now
Dual(DelivID, Match(DelivID,'3AM','8AM','1PM','3PM','5PM-WK','8PM','11PM','OUTS','STAT',' '))
Script : you can add
Dual(DelivID, Match(DelivID,'3AM','8AM','1PM','3PM','5PM-WK','8PM','11PM','OUTS','STAT',' ')) as DelivID
In this was you don't need to add calculated dimension in all the charts in which you use this field.