If I SELECT only a particular Manufacturer on the pivot table, all other manufacturers are not removed from COLUMNS, and all the Measure values are change to Zero, except for the one I have selected.
What I would like to see is the only manufacturer(s) shown on COLUMNS to be the one(s) I've selected. I believe the all "ALL" modifier is doing this, but I don;t know a way to force to only show the manufacturer I selected without affecting the expression total on the Pivot Measure.
Tried that, but since the values for those columns were "zero", it would not hide the columns, I even tried to update the expression with an "if " to convert the zeros to null(), but it did not hide them. I was able to resolved it by using Add-ons=>Data handling => and unchecking "include zero values".