
1. Re: How to convert YTD in each category into percentage?
Stoyko Kostov Aug 24, 2016 12:44 PM (in response to chun wey teo)Hi, Chun Wey,
You shouldn't try to replace the YTD total with monthovermonth (MOM) percent difference. The 2 indicators have different purposes.
For the % diff, you should use Tableau's builtin table calculation. Let's say you want the MOM % diff on Sales. You can duplicate the Sales measure, drag it to Text, and rightclick on the copy and choose Quick Table Calculation  % difference (assuming your data is already partitioned by month).
You can still keep the YTD total and sort by it.
Let me know if this doesn't make sense. Please attach a sample workbook in that case.

2. Re: How to convert YTD in each category into percentage?
chun wey teo Aug 24, 2016 10:30 PM (in response to Stoyko Kostov)Hi Stoyko,
thanks for the response.
You are right, I should not mixed them up. Customer was asking for YTD % and was thinking the denominator based from previous time period.
YTD % was refer to the based denominator since the start of period and not based from previous time period.
So in this context, it would make more sense to get the Jan data and use as denominator for each coming months. Right now, just need to find the formula for this and it should get the job done.
Thanks!

3. Re: How to convert YTD in each category into percentage?
Stoyko Kostov Aug 25, 2016 10:18 AM (in response to chun wey teo)Then what may work is the Tableau builtin table calculation called Percent of Total?
If you have data from previous years and your customer wants the YTD% just for the current year, you can filter out the previous years. If you still need to show them, but the calculation is performed only on the current year, you can split into 2 sheets with different filters and then combine them in a dashboard.
Again, if you give me some sample data, I think I'll be able to help you better.

4. Re: How to convert YTD in each category into percentage?
chun wey teo Aug 25, 2016 7:37 PM (in response to Stoyko Kostov)Hi Stoyko,
I think I got it. Went to search for YTD% definition, it is based on the first month or first FY month as the base denominator for the coming months. Example, Jan month shows 100 sales, Feb shows 200 sales, Mar shows 50 sales made. YTD % should reflect Jan 0%, Feb 100% and Mar 50%.
This can be done, via percentage difference. Choose pane across to run calculation each category and based calculation on First.
This will ensure calculation is run for each pane based on the first month.
As for the sample data, apology for it as I was working on actual data.
Thank you so much for your help!