Banks Records in Pivot

0

Hello,

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.

Regards,
Lakshman

Answer
Discuss

Answers

0

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

Discuss

Answer the Question

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