I'm not sure I understand how your data is arranged. If you have different columns, all you need is a calculated field that aggregates the 2 revenue figures.
If you have all these metric names on the same column and a value column, you would need to group the revenue metrics together so they are aggregated.
It's hard to tell without seeing the actual data. Could you post a packaged workbook?
Is your original data in Excel? If so, you might want to re-shape it, as its very simple to do so. If each value was in its own column, this would be much easier to do. You can still do it, but if its an option, you may want to re-shape the data.
It was a grouping that i needed to do. I was attempting a calculated field which is not possible for the way it is set up. that wasn't obvious to me but it is now that i can see the option.
This is useful however we aggregate a lot of our data into tables(due to the volume of data we have) and will have to do these types of calculations in the futures. When grouping it adds the two fields being grouped. is it possible ( i can't see that it is) to group and have one field divided by another or for the original example i have given if i wanted to see how many skills (from new skills) were added on average by daily new users. so in our example below 300/200. we cannot group in this scenario and i'm back to attempting a calculated field that is not possible. is there a workaround for this case?
column name value
daily new users 200
new skills 300
adsense revenue 40
indeed revenue 500
It would be helpful to see the view you are trying to create, even if it's in an excel spreadsheet or picture.
You can create a calculated field that aggregates the measures and does the calculation you want:
[ratio] = sum( IF [column name] = "new skills" THEN [value] ELSE 0 END) / sum( IF [column name] = "daily new users" THEN [value] ELSE 0 END)
How well this works depends on what else is in your view. Hopefully, this points you in the right direction.
If it doesn't, please provide a packaged workbook and a visual representation of what you are looking to create and I'll give it a try in Tableau.
Your calculation cannot be a dimension. You would have to either add it to the text shelf or use measure names/measure values.