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!
Quote from: lao24 on 24 Nov 2014 01:55:09 PM
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.