New Report - combining columns

[andrewjones11]

Hi! 

I'm creating a report and I'm struggling to figure out how to show something in a graph. 

Is it possible to show the following:

if Opportunity Ref has a value & Primary Quote is true, then show Estimated Value. Can this be done in a created column so I can use this in one visual? 

Example of values below:

Opportunity Ref	Primary Quote	Estimated Value
Ty Enfys 180521	True	60000
Morgan 230621	True	50000
Natural White	False	10000
	True	5000
	False	150000

So for the top 2 rows which have an Opportunity Ref value, & Primary Quote = True, I'd like the Estimated Value to show in the visual. 

Is this possible? All help appreciated.

[Samarth_18 · Accepted solution]

Hi @andrewjones11 ,

Create a column with below code and use it on visual:-

Column = 
IF (
    AND (
        'Table (7)'[Opportunity Ref]  <> BLANK(),
        'Table (7)'[Primary Quote]
    ),
     
    'Table (7)'[Estimated Value],BLANK()
)

Output:-

Since other values are blank thats why it is not visible on visual so if you want to see those as well then enable Show item with no data

output:-

Thanks,

Samarth