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
|