The following problem occurred to me. I have a base for each quarter, which I am concatenating as they are loaded until a single table remains.
The totals of each quarterly amount are accumulated so that in order to obtain the value of the amount for that quarter I must calculate it.
To do this assemble the following table, so that my need can be understood.
YEAR - QUARTER
201504 - 201503
201601 - 201504
201602 - 201601
In the first column is the period that specifies the YEAR and the QUARTER. In the second column, the value of the accumulated amount for each quarter. Here I make a couple of clarifications: when the quarter is 2 (for example, 201602) the accumulated is also the annual accumulated. The other point to note is that the first quarter, that is, the quarter that only accumulates "its" quarter is 3 (for example, 201503). The remaining two columns represent the value that should be the amount of each quarter and how it is calculated.
The indicators that I must develop must show the amounts of the current and (and selected) quarter and the previous quarter and year. For this, I have on the dashboard a selector of YEAR and a QUARTER.
The expression I am using, is the following but I am given 0.
Unfortunately it is not what I need. The table with which I count, among many fields is the following:
YEAR - QUARTER
Through this table I have to obtain the quarterly values (Column QUARTER) that are obtained from the expression (Column EXPRESSION).
When I want to replicate what happened to Andrey, I get the following and all I did was modify the name of the dimension:
Always the quarter ending in '03' (Example: 201403,201503, 201603, etc) will have the same value for TOTAL VALUE as for VALUE QUARTER. If the first record is 201504, you should not apply the RowNo () = 1.
I appreciate your response and predisposition to help me solve this.