-
1. Re: Adding percents within scope of row
Deepak Rai Mar 7, 2018 9:29 AM (in response to Jordan LeGrand)Welcome to Community. In this type of situation you described, it is easy to get help if you attach some example workbook with expected results. That helps.
thanks
Deepak
-
2. Re: Adding percents within scope of row
Devhuti Kumari Mar 7, 2018 9:45 AM (in response to Jordan LeGrand)Hi Jordan,
You can change scope of table calculation by doing right click on your calculated field -> compute using -> table across and see if you are able to show % of records at user level.
-
3. Re: Adding percents within scope of row
arvindgarg Mar 7, 2018 9:48 AM (in response to Jordan LeGrand)There can be many ways to achieve this. Let me explain one step using LOD
So you need - 1467 / (1467+ 3918) = 27 %
For numerator - sum(adj rsn column)
for denominator - { Fixed Name :sum(adj rsn column)} OR Total ( sum(adj rsn column))
If you can attach packaged workbook. it will be far easy to explain.
-
4. Re: Adding percents within scope of row
Jordan LeGrand Mar 7, 2018 9:58 AM (in response to Deepak Rai)Thanks for the advice, I just added the packaged workbook. I hope that works.
-
5. Re: Adding percents within scope of row
Eric Hammond Mar 7, 2018 10:00 AM (in response to Jordan LeGrand)Hi Jordan,
Drag the number of records measure onto "Label" under Marks.
Right-click the SUM(Number of Records) pill, quick table calculation, percent of total
Right-click the pill again, edit table calculation, select Table (across)