Analytic Function : “Percentage of Total” how can I get the results I want?
29 June, 2011
I am trying to use the Analysis calculation method called "Percentage of Total" in a report.
Metric: Effort
Calculation: % of Total Effort
When applied to a column layout, the value for % of Total Effort calculates correctly. However, I need to be able to calculate % of Total Effort across Months. If I extend the report to include this dimension in the column format, the % of Total Effort is calculated across the entire dataset i.e. several months. As I actually need to calculate % of Total Effort (for the total Monthly Effort), the result in the column format is inaccurate for my needs. If I apply the same fields to a crosstab format, the % of Total Effort field ceases to calculate at all, it just displays the Effort.
Please can you advise how my report can be designed to work as needed?
Cheers
Metric: Effort
Calculation: % of Total Effort
When applied to a column layout, the value for % of Total Effort calculates correctly. However, I need to be able to calculate % of Total Effort across Months. If I extend the report to include this dimension in the column format, the % of Total Effort is calculated across the entire dataset i.e. several months. As I actually need to calculate % of Total Effort (for the total Monthly Effort), the result in the column format is inaccurate for my needs. If I apply the same fields to a crosstab format, the % of Total Effort field ceases to calculate at all, it just displays the Effort.
Please can you advise how my report can be designed to work as needed?
Cheers
Hi,
I think in order to get the results you were after, for the column based report, you could use report sections (sounds like you may want to section by the field ?months?).
Example:
With the cross-tab report, this should work ok, though bare in the mind, the analytic function will calculate across the columns .
Example:
Please let me know if this doesn?t give you the results you were after.
Regards,
Steven
I think in order to get the results you were after, for the column based report, you could use report sections (sounds like you may want to section by the field ?months?).
Example:
With the cross-tab report, this should work ok, though bare in the mind, the analytic function will calculate across the columns .
Example:
Please let me know if this doesn?t give you the results you were after.
Regards,
Steven
Hi,
Is there an advanced function or conditional format to enable "Percentage of Subtotal"? i.e. other than using report sections.
Regards,
Samuel
Is there an advanced function or conditional format to enable "Percentage of Subtotal"? i.e. other than using report sections.
Regards,
Samuel
Hi Samuel,
There is no advanced function for "Percentage of Subtotal". I have made an example that could achieve what you are after:
E.g.Enable subtotals for Agency type and then apply "Percentage of Total" for the cost of camp.
Was this what you were after?
Regards,
Steven
There is no advanced function for "Percentage of Subtotal". I have made an example that could achieve what you are after:
E.g.Enable subtotals for Agency type and then apply "Percentage of Total" for the cost of camp.
Was this what you were after?
Regards,
Steven
Hi Steven,
Is it possible to show the Percentage of subtotal like the picture below?
Thank you.
Is it possible to show the Percentage of subtotal like the picture below?
Thank you.
Hi,
Below is an example of a report very similar to what you requested.
I used Agency Type as a Section and it calculates the Percentage of Total for each Section.
Please let me know if this is what you were after.
Regards,
Stephen
Below is an example of a report very similar to what you requested.
I used Agency Type as a Section and it calculates the Percentage of Total for each Section.
Please let me know if this is what you were after.
Regards,
Stephen