
1. Re: Percent of Total of numbers which are already in % terms
John Sobczak Jun 2, 2016 8:22 AM (in response to Ramesh Krishnan)1 of 1 people found this helpfulWould not divide by 2 give you what you need?

2. Re: Percent of Total of numbers which are already in % terms
Ramesh Krishnan Jun 2, 2016 8:41 AM (in response to John Sobczak)Hi John,
Thanks for your quick reply. This solves my problem but then, shouldn't Tableau itself be giving it on a scale of 100%?
Or is it always on a scale of 200% and we need to scale it down like this?
Thanks,
Ramesh

3. Re: Percent of Total of numbers which are already in % terms
John Sobczak Jun 2, 2016 10:12 AM (in response to Ramesh Krishnan)I think it has something to do with the way it is aggregating the total  not knowing the original measure is a ratio. If you change your ROI calc to be row level calc [return]/[investment] it comes to 100%. Maybe someone else can explain this better.

4. Re: Percent of Total of numbers which are already in % terms
Ramesh Krishnan Jun 2, 2016 11:33 AM (in response to John Sobczak)Yeah, seems like that. Thank you!

5. Re: Percent of Total of numbers which are already in % terms
Ramesh Krishnan Jun 4, 2016 12:57 AM (in response to John Sobczak)Hi John,
Realized that we can get what I want by using a level of detail expression.
What I did:
1. Created a new custom date field (I call it Custom Week Number) with date value of week number. Right click on the date field in the dimensions pane > create custom date > in the popup choose 'week numbers' in detail.
2. Used the below formula to calculate the ratio
{FIXED [Custom Week Number],[Investment Category]: sum([Return])/sum([Investment])}
3. Used this in the columns shelf and then added a table calc to this measure (percent of total, table down).
And I got what I wanted.
Hope someone finds this useful.
Thanks,
Ramesh