I have 2 tables WarrantyClaimMaster and TReportMaster. WarrantyClaimMaster has a field TractorSrNo which is aliased as TrSrNo and TReportMaster has a field TractorSrNo. Now i want to display count of TractorSrNo from table TReportMaster in my first expression and how many of those count, matches with TrSrNo of WarrantyClaimMaster table.
The problem here is , my first expression should vary based on the calender, but the second expression should give all the matching count from TrSrNo irrespective of year and month.
Also WarrantyClaimMaster table and TReportMaster table are concatenated to make common date field. Hence TractorSrNo and TrSrNo in the same table after reloading.
Thanks in advance
Thanks for your quick reply. In expression 2, i want the matching count of TractorSrNo and TrSrNo. i.e, say there are 100 count of TractorSrNo for month of June, then what is the matching count of TrSrNo(common data between TractorSrNo and TrSrNo) irrespective of year,quarter,month.
Your sample qvw seems to be blank. Re-upload with a small set of data and try to explain expected output against at least two different selections with logic explanation.