Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In this simplified example I have Year and Month as dimension and sum(value) as expression.
Now I want to have the sum(value) displayed as a percentage of the first month.
When I have a table-chart it can be done by showing the absolute value and use the the function before, but I cannot get it done in a line chart, in which I only want to show the percentage.
Please see example
Try this
=sum(value)/sum(total value)
Total would give me the total of all months I think, and should be the total of the first month of the year
This will work
=(sum(value)/sum(Total <month>value))*100
(Total <month>value)) will give me the sum for every month number. I need the sum of the first month per year
Think I solved it:
sum(value)
/
sum( {<month={1}>} TOTAL <year>value )