Hello MS,
Any idea when we might get some additional quick calc options?
(shameless copy and paste from show value as excel pivot functionality)
% 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))
I'm really missing this stuff in powerbi desktop.
