Forum Discussion
Kudo CommanderQuick Calc % Row Totals not working
ironryan77 and Vvelarde
People take these things to mean the same but they are different % of Row Total and % of Parent Row Total
See Below :smileyhappy:
No Calculation
Displays the value that is entered in the field.
% of Grand Total
Displays values as a percentage of the grand total of all the values or data points in the report.
% of Column Total
Displays all the values in each column or series as a percentage of the total for the column or series.
% of Row Total
Displays the value in each row or category as a percentage of the total for the row or category.
% Of
Displays values as a percentage of the value of the Base item in the Base field.
% of Parent Row Total
Calculates values as follows:
(value for the item) / (value for the parent item on rows)
% of Parent Column Total
Calculates values as follows:
(value for the item) / (value for the parent item on columns)
% of Parent Total
Calculates values as follows:
(value for the item) / (value for the parent item of the selected Base field)
Difference From
Displays values as the difference from the value of the Base item in the Base field.
% Difference From
Displays values as the percentage difference from the value of the Base item in the Base field.
Running Total in
Displays the value for successive items in the Base field as a running total.
% Running Total in
Calculates the value as a percentage for successive items in the Base field that are displayed as a running total.
Rank Smallest to Largest
Displays the rank of selected values in a specific field, listing the smallest item in the field as 1, and each larger value with a higher rank value.
Rank Largest to Smallest
Displays the rank of selected values in a specific field, listing the largest item in the field as 1, and each smaller value with a higher rank value.
Index
Calculates values as follows:
((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total))
This kind of oversimplifies it (especially the bottom example) because I had to apply slicers so you don't exactly see the benefit of the % of Parent Row Total (and in this case it looks like % of Column Total even though its not) but just to give you an idea...
Kudo CommanderIf I understand the purpose of Quick Calc % Total Row, then it should sum both 2015 and 2016 charges. Otherwise, how would % Total Row be any improvement on No Calculation? Also, this is how % Total Columns works except on Rows instead.
Community Championironryan77 and Vvelarde
People take these things to mean the same but they are different % of Row Total and % of Parent Row Total
See Below :smileyhappy:
No Calculation | Displays the value that is entered in the field. |
% of Grand Total | Displays values as a percentage of the grand total of all the values or data points in the report. |
% of Column Total | Displays all the values in each column or series as a percentage of the total for the column or series. |
% of Row Total | Displays the value in each row or category as a percentage of the total for the row or category. |
% Of | Displays values as a percentage of the value of the Base item in the Base field. |
% of Parent Row Total | Calculates values as follows: (value for the item) / (value for the parent item on rows) |
% of Parent Column Total | Calculates values as follows: (value for the item) / (value for the parent item on columns) |
% of Parent Total | Calculates values as follows: (value for the item) / (value for the parent item of the selected Base field) |
Difference From | Displays values as the difference from the value of the Base item in the Base field. |
% Difference From | Displays values as the percentage difference from the value of the Base item in the Base field. |
Running Total in | Displays the value for successive items in the Base field as a running total. |
% Running Total in | Calculates the value as a percentage for successive items in the Base field that are displayed as a running total. |
Rank Smallest to Largest | Displays the rank of selected values in a specific field, listing the smallest item in the field as 1, and each larger value with a higher rank value. |
Rank Largest to Smallest | Displays the rank of selected values in a specific field, listing the largest item in the field as 1, and each smaller value with a higher rank value. |
Index | Calculates values as follows: ((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total)) |
- Sean
This kind of oversimplifies it (especially the bottom example) because I had to apply slicers so you don't exactly see the benefit of the % of Parent Row Total (and in this case it looks like % of Column Total even though its not) but just to give you an idea...
- ironryan77
Awesome! This was exactly what I needed!
- ironryan77
I still don't understand how % of Row Total helps, but thank you for explaining all of the options. I probably won't be using % of Row Total since I don't understand what it does.