Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
check this:
expression should be
sum({ <mes, articulo >} stock)
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
check this
Hi,
Try this:
sum ({$<mes=, articulo=>} stock)
Regards
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
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
Hi Gonzalo,
I got your requirement , please find the attachment for the solution , its bit tricky
I appreciate your effort
But the problem persist
it appears months without sales like
mes mes
1 -
when you select month 2
Thanks
hey did you check the attachment ?? which i sent earlier