how to sort amount values when forced to zero some of values based on condition?

[srinivas1921]

Hi All,

I have created a pivot table with fields are Customer No.,Customer name,Product_status and Amount_1, Amount_2.

as per our requirement we need to force to '0' for all Amount_1 values where Product_Status = closed and we have implemented but the sorting was incorrect as below.

Please suggest a solution on this.

Intial Report results and sorting needs to be done based on Amount (descending order):-

Customer No.	Customer Name	Product_Status	Amount
101	AAA	closed	524
202	BBB	booked	430
303	CCC	closed	322
401	DDD	booked	230

results after applying condition:-

Customer No.	Customer Name	Product_Status	Amount
101	AAA	closed0	0
202	BBB	booked	430
303	CCC	closed0	0
401	DDD	booked	230

expected Results:

Customer No.	Customer Name	Product_Status	Amount
202	BBB	booked	430
401	DDD	booked	230
101	AAA	closed	0
303	CCC	closed	0

[sunny_talwar]

Would you be able to share a sample of what you are trying to do?

[Anil_Babu_Samineni]

After loading you are getting Product_Status has 0 Append. Is that is correct / Wrong enter

Match([Customer No.], 202,401,101,303)

[lancemayhew]

Click on the "Amount field" under the sort tab in the properties. Sort this field by Numeric Value.

It seems that your expected results are not sorting by this.