Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Banks Records in Pivot



I have two company codes (DU10 & CH10) and each has various cost centers. When I select one company code (DU10) I still see cost centers of DU10 & CH10, but here CH10 cost centers doesn't show any numbers since I selected DU10.

When I select one company code I don't wan to see other Company Code data.

Ex: If in the attached screenshot I selected DU10 as company code in first filter, then I still get CH10 Cost Centers, though data is blank but I don't want to see even that blank records also since those are related to other company code.

Kindly suggest some answer. In screenshot I am also showing my excel version.





May need to see how the data looks. Can you attach too?


Answer the Question

You must create an account to use the forum. Create an Account or Login