Sorting with formulas

[DanielT1424]

I am not able to sort data which are results from formulas. Can someone tell me why is it not working to do a simple sorting?

[#2]

@DanielT1424 

Could you please to give bit more details, desirably with sample? As variant you try to sort numbers, but actual data is texts which only looks like numbers. Whatever.

[#3]

@DanielT1424 

Thank you for answering. 

The third column has formulas that is giving those results. But when I am using the sort function, it does nothing. Every number is format as numbers, not text. I want to sort from the smallest to the highest number.

[#4]

Are you working in a PivotTable?

[#5]

@Patrick2788 

Yes, I am working with pivot tables. I thought it was that, so I have used formulas getting the values from the pivot table, sort function did not work. So I have tried with a simple formulas like this one, not coming for the pivot table

As you can see, 60 is a formula. a are values and b are the results of 60 + each line of a. The sort function still did not work. I do the same in another sheet of the pivot table, then the sort is working. Why?

[#6]

@DanielT1424 

Perhaps you may share sample file?