How to hide datavalues of a pivot for a particular rowitem value
up vote
0
down vote
favorite
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,57021026
asked Nov 22 at 14:35
LongtermUser
61
add a comment |
up vote
0
down vote
favorite
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,57021026
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 |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
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,57021026
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,57021026
asked Nov 22 at 14:35
LongtermUser
61
edited Nov 22 at 18:22
Federico Grandi
2,57021026
asked Nov 22 at 14:35
LongtermUser
61
edited Nov 22 at 18:22
Federico Grandi
2,57021026
edited Nov 22 at 18:22
Federico Grandi
2,57021026
edited Nov 22 at 18:22
Federico Grandi
2,57021026
2,57021026
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
up vote
0
down vote
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',
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
up vote
0
down vote
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 |
up vote
0
down vote
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 |
up vote
0
down vote
up vote
0
down vote
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