This content has been marked as final.
Show 3 replies
-
1. Re: Add %age column
Kathryn Bridges Aug 29, 2016 7:43 AM (in response to Prem Kumar)Hi Prem,
What I would suggest is creating calculated fields for these percentages (Before %, After %, and On Time%).
Once these are created, you can drag "Measure Names" to your columns to separate them out.
Please see attached workbook for example.
Thanks.
-
MeasureNamesColumns.twbx 1.2 MB
-
-
2. Re: Add %age column
Prem Kumar Aug 31, 2016 10:59 PM (in response to Kathryn Bridges)Hi Kathryn,
Thanks for your reply with an attachment. I'm using version 9.2 and hence, unable to use your example.
Thank you,
Prem
-
3. Re: Add %age column
Kathryn Bridges Sep 1, 2016 6:29 AM (in response to Prem Kumar)I've updated in 9.1. Please find attached.
This is using Superstore data, so in your data, you'll probably need to put a little more logic in the "% of Total Calculations" (Something like, "If [OnTime] = "Before" then [Forecast] else null end" for each time period, and then doing a Table Calc of Percent of Total on those.
Thanks!
-
MeasureVallueRows.twbx 1.2 MB
-