Getting the quarters right using expressions in charts
I have accumulated data over the quarters and the year and need to get the quarters separated and summed correctly. The dimensions used is the chart are FY and Quarter. I am receiving different numbers although the logic seems to be right to me. However I noticed that the expression I write is for some reason not executed. So maybe someone has been in my situation before and has some answer. In another chart I tried to combine the key word 'Total' with my expression but I have worse results. (it is also in the project if you would like to have an idea about it).
Attached are some helping screenshots and source files to help you understand my problem and how the results should look like, you might need to change the directory according to yours 🙂
Could you please have a look at it when you have time, unfortunately last week I was not able to touch or edit my own post for some reason!! today it works 🙂
The post is ready and has only 2 charts now, in the 1st chart I have an expression that its logic seems correct to me but I see that none of it is applied), the other chart I used Total within the expression and it still does not work (Total freezes one dimension and dismisses the other years). Also for some reason the quarters aren't ordered right.