Forum Discussion
Identify 2 different rows under the same table
Thanks all,
Let me take some time to apply the above solution and let you know the outcome.
Many thanksClement
Anonymous
- Point one is clear. My understanding is that once start and end report dates are selected you want to display a table that contains only the PO numbers which are available in both report dates with quantity of only the first date. Therfore, as per the sample data the grand total will show 600. Is that correct?
Still need more clarification on point 2. My understanding is that this is another report/table that will disply the the two selected report dates. This time we need to compare the date column. If the same PO in both earlier report date and later report date has the same date then we count the PO's that have the same date using one measure (count of same date PO's) and sum the quantity of these PO's using another measure (qty of same date PO's)
anoth teo similar measures to count the number of dissimilar date PO's and their quantity. One more measure to disply the diffence between dates in days. Is that correct?
Hi Tamerj1
Point 1 your understanding is correct.
Point 2 in fact I only have 1 table that same as sample date. I did not create any other table for report date or other data. Is it still possible to compare same POs under selected report date to determine how many PO and qty with same "date" and different "date". If they are with different dates, also found out PO count and qty per day different. e.g.
Same date PO = 3 POs and 300 qty (PO7-PO9)
Diff date PO = 3 POs and 300 qty (PO4-PO6)
2 days diff = 3 POs and 300 qty (PO4-PO6) (in case we have other days diff like, will also list out each days diff PO and qty).
or just simply list out no of days diff PO and qty, then I can assume day diff is 0 meaning same date.
Thanks
Clement
Anonymous
Ok I think this is almost the same as my initial understanding. But how are you planning to display the results? In card visuals?