If you notice carefully, measures like Asset Under Management/ Account Balance/Headcount all follow a very typical behavior, unlike most other values. They are:
1. These kind of metrics are not summable across periods
2. These kind of metrics are summable in the same period
3. For any given period, there are two values- beginning amount and ending amount.
4. Beginning Amount of one period is the Ending Amount of the previous period.
Is there a particular easy way to incorporate these features in one measure? Or do we have to define this behavior individually for the given context using formulas.
The answer may depend on what you data looks like and your expected result as well. It is not easy to say without seeing anything.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...