I tried using the aggregate sum function in but it wont work since i need the factor in the other table. Which is where my challenge started
To compute the rows below the report
points = sum per column * weighting factor per column
Score = sum of no of shops visited (in this case its 5) * weighting factor per column
% score = points/Score * 100
The report should display as described above. With the new computed rows below.
I kindly ask anyone to assist me with this challenge as i tried searching on the internet for solutions but havent come across any.