Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a pivot table with a Row with a field called 'Sub Area' and have a nested if in the column with the expression '
if(Stops='Stops','Stops',
IF(Print=''
,'Mplan'
,if(Print=1
,'WIP'
,if(SchStart<MonthEnd(today())
,'Late to launch'
,'To be launched'
)
)
)
) '
So the labels along the column heading will be WIP,STOP , LATE TO LAUNCH AND TO BE LAUNCHED.
Is there a way to sort this column heading in a specific order, say Late to launch, M-Plan, To be launched, WIP, Stop ?
Many Thanks
CR
'
sort by expression
match([Sub Area], 'LATE TO LAUNCH' ,M-Plan','TO BE LAUNCHED','WIP')
Note that case matters you show both so just make sure it matches what you really have.
sort by expression
match([Sub Area], 'LATE TO LAUNCH' ,M-Plan','TO BE LAUNCHED','WIP')
Note that case matters you show both so just make sure it matches what you really have.