Last 4 months

[spividori]

Hi.

I have as the Year field dimension and sum (Qty) as expression.

Need in the pivot table "Evolucion de Gastos" show only the last 4 months where sum (Qty) is greater than 0.

Regards.

[#2]

can u please post the sample qvd

i would like to look at the formula

[#3]

Hi Sandro ,

Can u clarify one case for me.

u want last 4 months which are in a sequentialorder without zeros or a starting month of last 4 without a zero but not others ?

thanks

Meher

[spividori]

Hi.

Here attached the file.

I need the chart "Cuadro de Gastos" shows the last 4 months with movement.

In the attached file should show: ago 11, jul 11, jun 11 and may 11.

As shown in the image:

When Sep 11 has as movements should show sep 11, ago 11, jul 11 and jun 11.

Sorry, my English is poor.

Regards

[spividori]

Hi.

Any suggestions?

Regards.

[lironbaram]

hei

attach is what you asked for

hope its helps you

[spividori]

Hi.

Could be, but should appear as selected 4 months, and I need it for other types of graphics.

Regards.

[lironbaram]

hei

try this