Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |