#1
|
|||
|
|||
Remove any pivot table fields with a blank entry
I have a table that I want to create a dynamic pivot chart, but I can't figure out how to apply this logic correctly:
If Proposed Cost > 0 and Actual Cost == blank: Show Proposed Cost ONLY Else: Show Actual Cost ONLY A simple table I have may look like this: Name // Proposed Cost // Actual Cost A // 100 // 125 B // 100 // 100 C // 50 // D // 75 // 150 E // 100 F // 90 What I'd like my pivot table to do is every time I select a macro'd table, it shows me one of two things: JUST the Actual Cost or JUST the Proposed Cost So for the ACTUAL COST, I'd expect to see info for persons A, B, D For the PROPOSED COST, I'd expect to see info for persons C, E, F Is there a way to make this a macro so that Excel is smart enough to know that when I click on the PivotTable fields to clear them and de-select ONLY those fields marked as blank, it will return the expected results in my Pivot Table? Thank you! |
Tags |
blank fields, macro, pivot tables |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to remove the last comma at the end of a table entry | lmvantassel | Mail Merge | 3 | 11-03-2016 12:53 PM |
Show calculated fields within the Pivot Table | John in DSM | Excel | 2 | 09-07-2016 02:12 PM |
Displaying 0% as blank in pivot table? | New Daddy | Excel | 4 | 12-06-2013 08:28 AM |
how to remove blank box on top-left corner of table in PPT 2010? | dylansmith | PowerPoint | 3 | 10-18-2012 03:59 AM |
Pivot Table's fields | janis129 | Excel | 7 | 03-02-2010 03:16 PM |