Best practises for Total metrics in datasets

Hi, i am just wondering what is your opinion about including TOTAL metrics in a dataset.

I have a dataset that has a metric Revenue A and a metric Revenue B. Very often, users will want to see only Total Revenue ( which equals to SUM of Revenue A and Revenue B). 

What is the best practise here - should I include the Total Revenue in the dataset, or create it as a measure in Looker? What are the pros and cons?

Thank you

0 0 91
0 REPLIES 0
Top Labels in this Space
Top Solution Authors