Efficient expression and data model for QVW (cumulated margin by month)

[#1]

Dear Dariusz,

Can you show me how to have a more efficient expression and datamodel for the attached QVW files.

Kind regards

Michael

[#2]

Michael,

look for first idea and let me know what do you think about this direction?

regards

Darek

[#3]

And 2'nd direction.

I know, that there may be some differences, but let me know which direction you prefer ....

regards

Darek

[#4]

Dear Mariusz,

Thank you for your two examples

I think this solution is better because i need it to have in chart object.

Can you explain me what you want to mean with the value tech_month?

Kind regards

Michael

[#5]

for exampleMichael,

as tech_month i named additional dimension connected to oryginal month dimension.

Each tech_month value is connected to oryginal months used in your cumulated calculations.

So, we have data structure like this:

tech_month, month

1,1

2,1

2,2

3,1

3,2

3,3

......

thanks it for example 5'th tech month "knows" months, and, what is most iportant, also data for months 1-5.

So, if we put tech_month as dimension, we will have in each row of our chart data from all month we would like to accumulate in this row.

Of course it is still possible (uing set analysis) to show in this row some other KPI using data, where tech_month=month.

Let me know if you have additional questions or need more help.

regards

Darek