Row level calculation and Two measurements in one Growth view
May I ask two questions?
- First is that is that possible to do row level calculation using formula in TS? Basically I want to show by month Sales YoY%(month this year vs last year) and MoM% (this month vs last month) in one table.
- If the first question is not doable in TS, I can show monthly YoY % and MoM% separately. I know I can use key word Growth to show month over month. I can do something like "growth of Sales by date monthly". But it seems like this only works for one measurement at one table. Can I show MoM% of two measurements in one table? For example, "growth of Sales and Margin by date monthly"?
Thank you very much in advance. Any help is appreciated.
Hi, you can do this through formulas. The following thread gives a number of ways to calculate different periods. Then you can calculate the growth based on these.
There a number of replies from Craig HaughanReply