Change Total% to Average%

[tracycrown]

Dear all

Can someone help to change total of 100% to an average of 12.5% ?.

Thank You

Tracy

[Gysbert_Wassenaar · Accepted solution]

Change your % expression to avg(aggr(sum(Quantity)/sum(Total Quantity),Item))

[tracycrown]

Dear Gysbert Wassenaar

Thank you so much for your quick response.

You are so clever, I have a lot to learn.

Tracy