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