Ignore selection in dimension

[callmedaddy]

Hello,

I'm having this issue. I have a filter like that:

=Aggr(Only({<Company = {'X'}>} Product),Product, Category)

for showing only the products sold by company X, which selects  both the product name and the category as filters.

I also have a table with a single column: Company - in which I want to display all the companies that have products in that category selected previously (so basically, I need to ignore the Product selection). I tried:

=Aggr(Only({< Product = >} Company),Company) - but with no succes. It only shows company X.

Can you please help me with that? 

Thanks!

[lorenzoconforti]

Try using the set analysis in your measure in the table, not the dimension

[callmedaddy]

ONE MORE THING:

In script I generated RGB codes for each Company. The table I am talking about (it only has a column - Company) works as a "Legend" for another chart. I wanted to apply the background color of the field in the table as the color assigned in script, that's why I don't have any measure.

Any idea how to solve that?

[lorenzoconforti]

Not sure how you would be able to achieve it with just one column. The only advice I have is to include a second column anyway in which you can give some relevant information (like a count)