Results 1 to 2 of 2
2011-08-05, 04:59 #1
- Join Date
- Aug 2011
- Thanked 0 Times in 0 Posts
Data show Filter for Multiple Criteria
I am having product details with 150+ record i want to summaries it is in summary sheet details as following
Work is being executed at different locations the same product is manufacture in all location but with different product no
For each day product survey report is generated with consecutive serial no of that particular area. Report No, Date , Bill no May be the same for for different location but product no will be different. eg . Nerul & Sanpada may have same report no but product no will be always different.
Here is one more report generated for further activities of a particular product no. which is necessary part of the bill
Since one report contains many product no and it is not always claimed in single bill hence bill no against particular product code may be different against these two different reports also report no may be repeated in different bill nos
Data is entered in a single sheet for all products and for all different locations.
It is desired to get the details of the product by selecting below parameters
Bill No ( Pertains to report name selected)
Details desired to out come
1 Report No Date Total Product
2. Product No Report No
No, of Product – No of product of that particular report
Total No. Product : Total No. of Product of that particular invoice.
Kindly suggest how to do it proper manner
2011-08-07, 09:42 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- Thanked 342 Times in 335 Posts
Not sure exactly what you want. Can you elaborate on the details? It seems to me that a pivot table may be the way to do it, though it would be a different format.