pdvsa
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
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
Previous version was to show only NULL or blank.
Now this one shows only with data without NULL or blank.
EE_PivotNULL_V2.xlsx
Now this one shows only with data without NULL or blank.
EE_PivotNULL_V2.xlsx
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.
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
I have separated them in two sheet, then you get the expected result.
Please try attached...
EE_PivotNULL_V3.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Please add VBA in your topic
EE_PivotNULL_V1.xlsx