My pivot table column is customer. Each customer has two status fields: field IMPORTANT:0,1 shows if they are important or not. field CUSTOMERSTATUS: new, old shows if the are new or old customers. I want to sort customer by: IMPORTANT=1, everything else, CUSTOMERSTATUS=new. How should I write the sort by expression expression without changing model?
Thank you in advance!