Hey guys, I have a question and I really hope you can help me fixing it.
As you can see in my picture, I have a list with different dimensions, subdimensions and statements. The main goal of my app is, that in the end the client can evaluate himself on the given statements on a scale of 1 to 5.
After the client has answered every statement, I would like to give him his overall result (for example: X/5) but also his results for each dimension (1. Strategy and Management, 2. Customer, 3. Culture, Organization and People, Operations, Technology and Innovation). For now each dimension has just two statements but the final app will contain many more statements. How can I calculate the average result for each statement. I checked out “Rollup” but that seems to work just for a whole column.
I highly appreciate your help.
Cheers from Berlin,