Hello friends, hope all is well!
please help, the attachment here has a sample /pivottable.
I need the pivottable to Not show the blanks in Nationality and Relation. Doing it manually on the pivottable is no good since it will remove the \
values of: Sum of Consultation Count AND Sum of Companyshare.
Is there a way to do it in a smoother way? thanks a lot in advance!
Hi,
I believe the only way is to have a space character in the 'empty' fields.
If you want overall Consultation and Company share stats. then it's obviously necessary to include all data however they are described.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Re: pivot table without blanks.
you can try Conditional Formatting and Custom Format
(blank) -> ;;;
Last edited by sandy666; 04-12-2018 at 12:41 PM.
Neat!Originally Posted by sandy666
I'd never have thought of a CF within a PT.
@Richard Buttrey
Why not? The same table as each other only that contains the grouping. There are a few limitations but I do not see them in 1 post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks