Show only complete MAT periods in chart

[#1]

Hi, I'm new to QV, and I have no scripting abilities, but I have to deliver a chart showing the MAT monthly sales figure.

I've already achieved the MAT calculation using an AsOf table, and have the chart plotted:

The problem is that it shows incomplete MAT periods (i.e. as I only have data until June-16, the following months have just 11, 10, 9, 8... months of sales data). As these MAT periods are not complete, I want to remove them from the chart.

Any clues how to do this?

Thanks for your help!

[sunny_talwar]

What is the expression that you have used?

[#3]

Hi Sunny,

In the AsOf table, each month is related to the corresponding MAT period. I'm using the MAT period as dimensión, so the expression is just a SUM function of the sales amount: sum(VI)

Hope this helps,

BR