Hi all,
I am trying to list top 'x' sales by Item, further subdivided by Item Variant (Our customer has various thicknesses of product to report on). Currently I am struggling to filter by Item Variant.
The 'Item' field pulls through as follows: =NL("Rows","27 Item",,"64 Datefilter",$I$4,"-78 Sales (LCY)","*","limit=",$I$5) and this works fine. I4 and I5 are date filter cells.
However because Item Variant table does not have any date filter fields I think Jet is pulling every variant for every item with this formula: =NL("Rows","Item Variant","Code").
I think I need to link the two together with ="Link" but I am not sure how - can I tell the Variant field to only pull through results for the Item generated in the first formula?
Apologies if that's confusing and thank you for any help in advance!
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi,
Well I don't know the exact structure of your report, but I think this should be relatively easy and shouldn't require Link=. You just need to NF function returning the No. field from your first formula. Then you can create a filter in your 2nd formula for the Item No. referencing the result of the NF function. Does this work for you?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
That was spot on, thank you for the help and quick reply.
After getting that filter to work I then had to understand why I was still getting 50+ results when "limit=" was set to '5' but I realised the Variants were not limited just because the Items were, so I have added another limit to ensure that I can control the number of results shown.
Steve
Please sign in to leave a comment.