How to do a if statement and sum the numbers in a certain column where fieldname=something?
Using a bar chart. If Company = “yahoo” then sum the numbers in values column where type=Search into one bar and sum the numbers in values column where type=Others in another bar. And where do I write the statement? in the (type) dimension or (value) measure?
Below pic is what I wanna achieve.
Below is what I have....whatever values that belong to google is also displayed but i do not want that.