forums

I have a worksheet where I'm counting the number of items that meet certain criteria, so my measure for the table is count distinct on a dimension. I'm trying to create a hyper link to another sheet so that you can not only see which items these are, but also see additional information on these items. When I try to create the hyperlink, it says that this dimension that I'm counting is not included. How can I include this item in the hyperlink so that on the destination sheet, I can see details on only these items.

One of the initial criteria is time based, and on the detail page I want to see other elements of time, so just passing every other dimension from the first sheet doesn't allow me to see other points in time, as the time would be filtered from the initial sheet.