ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   filtering in pivot tables (https://www.excelbanter.com/excel-discussion-misc-queries/164349-filtering-pivot-tables.html)

hans

filtering in pivot tables
 
I would need to show information in a column showing the values x and y only.
If only x or y has a value, nothing should be shown. This can be done
manually in the pivottable, but as the spreadsheet is quite large the amount
of work is tremendous.
So I would appreciate any tips.


All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com