Dimension with set analysis

[ziabobaz]

Hi,

I have two dimensions:

I want to build a table with Source as dimension.

However, I want to show only those Fileds, where Channel=Paid.

something like

={<Channel={'Paid'}>} source

I know I can put a Channel filter on the dashboard > choose 'Paid' as the table will show me the numbers.

My aim is to limit the clicks so the table shows 'Paid' Sources right away.

Thank you!

Gleb.

[vishsaggi · Accepted solution]

Try this as your dimension for Source

= Aggr(Only({< Channel = {'paid'} >} Source), Source, Channel)

[groveliam]

If the above doesn't work, you can try to just use a simple if statement. I do something similar in one of my tables. It would look like:

=if(Channel = 'Paid', Source)

Let me know if it does not work out, good luck!

[ziabobaz]

Both of them work, thank you!