Link to home
Start Free TrialLog in
Avatar of pdvsa
pdvsaFlag for United States of America

asked on

Pivot help - Display only Is Not Null

Experts,

I have a data set.
I made a pivot but only want to display rows that are not null (remove the rows with no data) for col B and C.  
I do not want to add a helper column

thank you

please see attached excel.
EE_PivotNULL.xlsx
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Hi Please try attached...
EE_PivotNULL_V1.xlsx
Previous version was to show only NULL or blank.

Now this one shows only with data without NULL or blank.
EE_PivotNULL_V2.xlsx
Avatar of pdvsa

ASKER

Shums, nice filtering.  V2

I am not sure it is displaying correctly though.
Example:  Jan 10 2017 should show 200 column B and Jan 11 should show -73.5 col C and I do not see either this date or the amount.  It seem to completely skip anything in January 2017 although I can see all dates have been tick marked.  

Let me know what you think on V2.  I did not understand V1 though.
Because in Report Filter, I had both WC & DO. If there is multiple Report Filter, it will list combined data.

I have separated them in two sheet, then you get the expected result.

Please try attached...
EE_PivotNULL_V3.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pdvsa

ASKER

very nice.  Excellent job.  thank you very much.
You're welcome and I'm glad I was able to help.

Please add VBA in your topic