How to hide datavalues of a pivot for a particular rowitem value
I have a request to show pivot as below.
x11111
y111111 8/10/2018 5/20/2018
z11111
x22222
y222222 5/20/2018 7/10/2018
z22222
The dataset behind this havs values for all datavalues, so I need to hide the datavalues that are corresponding to x11111,z11111, x22222, z22222 and so on.
I researched but unable to find an optimal solution.
excel vba
edited Nov 22 at 18:22
Federico Grandi
2,64521127
asked Nov 22 at 14:35
LongtermUser
61
add a comment |
I have a request to show pivot as below.
x11111
y111111 8/10/2018 5/20/2018
z11111
x22222
y222222 5/20/2018 7/10/2018
z22222
The dataset behind this havs values for all datavalues, so I need to hide the datavalues that are corresponding to x11111,z11111, x22222, z22222 and so on.
I researched but unable to find an optimal solution.
excel vba
edited Nov 22 at 18:22
Federico Grandi
2,64521127
asked Nov 22 at 14:35
LongtermUser
61
I've improved the post formatting: please remember to write your questions with a easily readable formatting :) Take a look at [the editing help] for more information
– Federico Grandi
Nov 22 at 18:22
add a comment |
I have a request to show pivot as below.
x11111
y111111 8/10/2018 5/20/2018
z11111
x22222
y222222 5/20/2018 7/10/2018
z22222
The dataset behind this havs values for all datavalues, so I need to hide the datavalues that are corresponding to x11111,z11111, x22222, z22222 and so on.
I researched but unable to find an optimal solution.
excel vba
edited Nov 22 at 18:22
Federico Grandi
2,64521127
asked Nov 22 at 14:35
LongtermUser
61
I have a request to show pivot as below.
x11111
y111111 8/10/2018 5/20/2018
z11111
x22222
y222222 5/20/2018 7/10/2018
z22222
The dataset behind this havs values for all datavalues, so I need to hide the datavalues that are corresponding to x11111,z11111, x22222, z22222 and so on.
I researched but unable to find an optimal solution.
excel vba
excel vba
edited Nov 22 at 18:22
Federico Grandi
2,64521127
asked Nov 22 at 14:35
LongtermUser
61
edited Nov 22 at 18:22
Federico Grandi
2,64521127
asked Nov 22 at 14:35
LongtermUser
61
edited Nov 22 at 18:22
Federico Grandi
2,64521127
edited Nov 22 at 18:22
Federico Grandi
2,64521127
edited Nov 22 at 18:22
Federico Grandi
2,64521127
2,64521127
asked Nov 22 at 14:35
LongtermUser
61
asked Nov 22 at 14:35
LongtermUser
61
asked Nov 22 at 14:35
LongtermUser
61
61
I've improved the post formatting: please remember to write your questions with a easily readable formatting :) Take a look at [the editing help] for more information
– Federico Grandi
Nov 22 at 18:22
add a comment |
I've improved the post formatting: please remember to write your questions with a easily readable formatting :) Take a look at [the editing help] for more information
– Federico Grandi
Nov 22 at 18:22
I've improved the post formatting: please remember to write your questions with a easily readable formatting :) Take a look at [the editing help] for more information
– Federico Grandi
Nov 22 at 18:22
I've improved the post formatting: please remember to write your questions with a easily readable formatting :) Take a look at [the editing help] for more information
– Federico Grandi
Nov 22 at 18:22
add a comment |
1 Answer
1
active
oldest
votes
I resolved this by changing the fonts to white so I get the above format, if anyone have better answer let me know
answered Nov 24 at 13:47
LongtermUser
61
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53433221%2fhow-to-hide-datavalues-of-a-pivot-for-a-particular-rowitem-value%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I resolved this by changing the fonts to white so I get the above format, if anyone have better answer let me know
answered Nov 24 at 13:47
LongtermUser
61
add a comment |
I resolved this by changing the fonts to white so I get the above format, if anyone have better answer let me know
answered Nov 24 at 13:47
LongtermUser
61
add a comment |
I resolved this by changing the fonts to white so I get the above format, if anyone have better answer let me know
answered Nov 24 at 13:47
LongtermUser
61
I resolved this by changing the fonts to white so I get the above format, if anyone have better answer let me know
answered Nov 24 at 13:47
LongtermUser
61
answered Nov 24 at 13:47
LongtermUser
61
answered Nov 24 at 13:47
LongtermUser
61
answered Nov 24 at 13:47
LongtermUser
61
61
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53433221%2fhow-to-hide-datavalues-of-a-pivot-for-a-particular-rowitem-value%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I've improved the post formatting: please remember to write your questions with a easily readable formatting :) Take a look at [the editing help] for more information
– Federico Grandi
Nov 22 at 18:22