Summarize in Output - Percentages

[lao24]

Hello,

I have a list that is successfully filtering based on variable values. I need to have a total line that will change along with the list as the filter changes - i.e. total for all items, then when an item is selected, total for that item only. I have it successfully working with the numeric values using the 'Summarize in Output' option and choosing 'Total', but I also need that functionality for a percentage - i.e. sales growth.

I haven't been able to get any of the 'Output Aggregation Methods' to work along with this, even after changing the aggregation of the data item itself to 'calculated', as I have seen in previous suggestions. Any of the methods do exactly what it seems like they would - adding up all the percentages so I get a huge percentage, not the actual total percentage.

Please let me know if you need more details! Any ideas?

Thanks!

[MFGF]

Hello,

I have a list that is successfully filtering based on variable values. I need to have a total line that will change along with the list as the filter changes - i.e. total for all items, then when an item is selected, total for that item only. I have it successfully working with the numeric values using the 'Summarize in Output' option and choosing 'Total', but I also need that functionality for a percentage - i.e. sales growth.

I haven't been able to get any of the 'Output Aggregation Methods' to work along with this, even after changing the aggregation of the data item itself to 'calculated', as I have seen in previous suggestions. Any of the methods do exactly what it seems like they would - adding up all the percentages so I get a huge percentage, not the actual total percentage.

Please let me know if you need more details! Any ideas?

Thanks!

I haven't been able to find a way to do this, sadly. In the end I had to switch from filtering my list to using a data deck with a pre-rendered version of the list on each card.

MF.