Add Percentage to Roadmaps > Analytics > Pivot

+1. One of our pivot reports totals a numeric custom field representing ACV. That custom number field uses a $ prefix, so I'd like the pivot to show the same prefix.

I would also like to add the use case of being able to add a $ sign to pivots with aggregated summary results.

Just to add to this with a specific example of what I'm looking to do - I have a pivot table that shows, per product, each feature with progress % for each status type. What I want to be able to do is sum and average the percentages to get a total % completion rate for the stage. So, if I have three features under In Progress status with progress bars at 50, 10 and 25%, I want to be able to show, under In Progress, 28% completed. Hopefully that makes sense!

Thanks for your help, Clark. Sorry for the confusion; we misunderstood your use case. Your additional explanation above helped us clear it up. We have updated this idea to Future consideration.

Thanks for the quick response, Clark. We are going to have someone from Customer Success reach out to you shortly to assist.

Hi

How are the column totals being calculated for use in the formula to calculate the percentage?

What function in the formula yields to total value of the column for the denominator?

* [ Cell Value / Total of Column ] * 100 = Percentage

Please share an example of such. Saying it exists does not help or else I would have done it in a list.

Thanks
-Clark

To be able to use calculated column you need a means to get the total for all the unique features and use the total in the denominator. So in the List Report, how does one get the totals for any attribute? Is there a function to insert into the formula that yields the total value, and total count of unique, or total count of occurrences, or total count of blanks? The trick is how to get the total in context to the percentage value being calculated. 

Can you please share a real world example of such a function inserted into the cell of a list report to yield the percentage? Please use a custom field as an example and not a native built in field. ALso show how the total / denominator is derived.

Thanks

-Clark

Thank you for clarifying, Clark!

You can accomplish this today by creating a calculated column in a list report: https://support.aha.io/hc/en-us/articles/360024956691.

Calculated columns can be added to pivot reports to display the calculation without having to adjust the pivot report settings. Please contact us at support@aha.io if you need any help setting this up.

Re-attached the original image per request. Thanks for taking the time to consider this enhancement to the Pivot table cells computations.

Thanks for sharing this idea. It looks like the image did not attach to the description. Can you please re-share so that we can better understand this use case?