![]() |
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 |
All times are GMT +1. The time now is 02:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com