Hi,
There are 5 title in my pivot table columns; "Material", "Montage", "Disassembly", "Reassembly" and "Common"
I want to remove "Common" area but it's values must seem both "Disassembly" and "Reassembly" areas. How can I solve it?
Thanks...
Hi,
There are 5 title in my pivot table columns; "Material", "Montage", "Disassembly", "Reassembly" and "Common"
I want to remove "Common" area but it's values must seem both "Disassembly" and "Reassembly" areas. How can I solve it?
Thanks...
you could help yourself and others trying to assist you in uploading your spreadsheet AND show what you believe your solution would look like (part of the Forum Rules too).... That being said, i can only guess at what it is that you mean...perhaps you could FILTER your data and delete the unNeeded items? Other than that, no clue as to what you mean.
Ok, ı upload file.
In Pivot table, there is "COMMON" columns.
Values of "COMMON" should appear in both "Reassembly" and "Disassembly" even if "COMMON" columns is removed or filtered.
How can ı solve it with formula, macro and another way?
On your Pivot Table where it says "Column Labels" click on the downward pointing triangle, this will show you what is called a Filter. Unselect 'Common' by clicking where the check mark (aka Tic mark) is and it acts as a toggle....click it once and it will unselect Common....click again and it will select Common. This is how you can filter the data to show or NOT show certain data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks