As you have used a lookup, the data will need to remain present for the lookup function to work - this, I am sure you now know, so exclusions will not work so, use an index filter: Index()
Create the calculation and drag onto the columns, right-mouse select and convert to discrete. You may have to play with the scope a little away from the default of Table (Across) but once you get the numbering correct, you can simply filter the index for those columns that represent the data you do not want to see.
This has the effect of hiding the columns without removing the data.
I can give you a hand with this later, but am off to a meeting right now.
Hi Steve, thanks a lot for bringing up "Index" !! However, I tried all options for "Tablea Acrossing/ down, ..." and this is the closest I could get. It seems like I cannot index columns crossing multiple measures?
The one below shows the Index repeated every measure, (I have 3 measures: [Countd of Shipment #s], [Avg of 2 months], [Avg of 3 months]), and the read ones that I drew are supposed to be the correct ones, so that I could hide 5,6,8,9.
SORRY to bother you for your meeting thingy!!!!
THANKS A LOT !!
Have you tried to move the index in the view to position 1 of your column fields, so it falls before Measure Names.