A calculated dimension which ignores user selection

[dafnis14]

Hi,

I would like to create a table with a dimension that ignores a specific selection of other linked dimension.

For example:

The calculated dimension is Product.

The selected dimension to ignore is Warehouse Type.

So the table has to show all the products, regardless of the selected warehouse type.

Unfortunately, I couldn’t find  solutions in previous posts.

Thanks!

[ashfaq_haseeb]

Hi,

Can you attach sample data

Regards

ASHFAQ

[MarcoWedel · Accepted solution]

=aggr(only({$<[WarehouseType]=>} Product), Product)

[dafnis14]

Thanks!

[MarcoWedel]

You're welcome

regards

Marco