Problem Sales and Stock

[#1]

Good Morning

I have the attached example, I need to show the selected articles with stock independent they have had sales.

I use the expresion sum({ <mes articulo >}  stock)

It shows all the months (with cero value in  sales when no selected that month) perfect!!

But it shows all the months (with cero on sales) I only want to display the selected months and all the articles with stock

I need the sales of the selected months and the stock of all the articles.

Thanks

[avinashelite]

check this:

expression should be

sum({ <mes, articulo >}  stock)

[#3]

Thanks for your answer but the problem persist.

If I select only a month  in the pivot table (2 for example) it stills show month 1 and 3 (with cero values) but I only want month 2 to appear of it has sales or null if it has no sales but has stock

Thanks

[avinashelite]

check this

[Marcellino_Groothof]

Hi,

Try this:

sum ({$<mes=, articulo=>} stock)

Regards

[#6]

Thanks again

Well, I think I'm not explaining

I need to show in the pivot table only the selected months.

If there is any sales in the select month it mast appear (in ventas)

If there is not sale in the selected month but there is stock for the article the month will be null and stock appears on column reference as stock

In my example if you select mes    2  and alll articulos

it must appear

articulo  mes  ventas   stock

1            2       20          10

2            -         0           20

3            -         0           30

4            -         0             5

And if you select mes 1 and all the articulos it must appear

articulo  mes  ventas   stock

1            1        10         10

2            1       200           20

3            1         10          30

4            -           0             5

Thanks

[#7]

Thanks for your response but i'm answering the same

I need to show in the pivot table only the selected months.

If there is any sales in the select month it mast appear (in ventas)

If there is not sale in the selected month but there is stock for the article the month will be null and stock appears on column reference as stock

In my example if you select mes    2  and alll articulos

it must appear

articulo  mes  ventas   stock

1            2       20          10

2            -         0           20

3            -         0           30

4            -         0             5

And if you select mes 1 and all the articulos it must appear

articulo  mes  ventas   stock

1            1        10         10

2            1       200           20

3            1         10          30

4            -           0             5

Thanks

Re: Problem Sales and  Stock

[avinashelite]

Hi Gonzalo,

I got your requirement , please find the attachment for the solution , its bit tricky

[#9]

I appreciate your effort

But the problem persist

it appears months without sales like

mes   mes

1         -

when you select month 2

Thanks

[avinashelite]

hey did you check the attachment ?? which i sent earlier