Filter data set in table

[Anonymous]

Hi,

I have a data model, with 2 types of ads: free and paid.

in the data model, I have a report thta shows all ads,

and a second report that shows revenues, clearly I need to show only the paid ads,

but what is the best way of doing this?

needs:

I don't want the user to use the report wrongly and show both types of ads

I want to present it in a straight table

[arulsettu]

hi,

try this

sum({<addtype={'paid'}>}amount)

[sunny_talwar]

Not sure what you requirement is? Do you want your revenue table to just show information related to paid ads only???

[Anonymous]

Exactly

[sunny_talwar · Accepted solution]

There is two ways I can think of doing this:

One would be a calculated dimension where you can use a if statement

If(ads = 'paid', yourDimension) and then you can suppress the null.

Alternatively, you can use set analysis in all your expressions:

{<ads = {'paid'}>}

I hope this helps.

Best,

Sunny