ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table - Sorting on Sum field and filterin (https://www.excelbanter.com/excel-discussion-misc-queries/91197-pivot-table-sorting-sum-field-filterin.html)

[email protected]

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