View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Pivot Table - Sorting on Sum field and filterin

Hi All,

I have the following pivot table:

Employee ID Working Hours Salary Incomes
Expense Computed Field (Incomes - Expense)
1 20 500 600 10 590
8 15 900 1500 300 1200


My questions a
1. I would like to sort according to the computed field - but have no
success (I tried Field - Advanced/// Nothing helped)

2. I would like that the user will not have rows where Working Hours =
0

I did many searches and used some ideas - but with no success

This is urgent - And I have no idea how to solve it (The data it is
based on is very dynamic - and changed very often)
Many thanks,
Malka