I am graphing 4 different items on a date vs. percent complete line graph. Each item is based on 100%. When I sort using a list box the data works because it is only showing one item which can reach 100%. When I remove the filter and show all items in one line it is equal to 400%. Is there a way to make everything work on a 100% scale using one line with or without the filter? Thanks for your help!
Maybe. If you post an example document that demonstrates the problem perhaps somebody can help you. If you want to try to figure it our yourself then investigate the total option for aggregation functions: sum(total <DimA> Amount). My guess is that you'll need that total option somewhere in your expression(s).