Thank your reply. However what I want to do is in one matrix use as columns the year dimension for pick-up date, and in another matrix use the year dimension corresponding to "Order Completed Date". Now, because the active relationship is between my date field in the date table and the "order completed date", if I drag the year dimension from my date table to columns it slices on the "order completed date". But in another matrix that is not what I want. I also want to use years as columns but these years should represent the years of the "pick up date" which has an inactive relationship with the date column of the date table. How do I use years referring to "pick up date" as columns in my matrix when the active relationship is with another date column in my fact table ("Order Completed Date")?
