Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
Can someone help to change total of 100% to an average of 12.5% ?.
Thank You
Tracy
Change your % expression to avg(aggr(sum(Quantity)/sum(Total Quantity),Item))
Change your % expression to avg(aggr(sum(Quantity)/sum(Total Quantity),Item))
Dear Gysbert Wassenaar
Thank you so much for your quick response.
You are so clever, I have a lot to learn.
Tracy