For first thing, try this
Add a new table in the script like this
LOAD * INLINE [
and then change your second dimension to this
Pick(DIM, SelectedColumn, 'Total')
Rest everything should stay the same.
For second thing, may be you just need this as your expression
Sum(Measure)/Sum(TOTAL <Month> Measure)
Thank you very much for the response.
Apologies for the delay in responding. I have been trying to understand more about the solution.
Firstly, it worked!
Although I have no idea how it works.
Can you explain please?
I have looked up the following and am still in the dark:
In respect of the result, it gave me a Dimension Line showing the total of the individual selected columns which is great.
However as Line Charts can only use Two Dimensions, I could not add this new Total Line to the chart with the individual lines. Namely, I had two graphs instead of one.
The only way around this that I could find was here i.e. adding both graphs to the Storey and making one graph transparent. more here: Ability to overlay charts, text and images
Is there a way to add a third dimension to a Line Chart?