Hello everybody!
I have a pivot table with teams on the rows and revenues as values. Then I have created a calculated field for Delta with the formula: SUM(IFNULL(Revenues_current_month, 0)) - SUM(IFNULL(Revenues_last_year, 0)) and inserted it in the pivot. It calculates the correct result, but when I try to sort the table on that field it doesn’t work. Specifically, when I save it deletes the order, it does not display the name of the calculated field in the pivot table and it changes the format of the field (from currency to number).
I want to add that this table has always worked. Each month I only modify the name of the calculated field (to adapt to the current month). Last time, the table stopped working, as I described above.
Do you have any idea what is going on and how can I solve?
Thanks for your support!