My pivot has 2 columns "Planned" and "Actual". As I want to show the variance of "Actual" from "Planned", I changed the table to show value as Difference from "Planned". This results in all blanks for "Planned" and the variance amount in "Actual". My question is: how can I sort by this "Variance-Actual" column and also filter by Top 10?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Sort by "Difference From" column
- Thread starter meileetan
- Start date
Similar threads
- Question
