Forum Discussion
Solved
How to filter a table based on a column's highest value
Hi, I am trying to calculate the total quantity by Quality from a table called "Data", but filtering on the highest value in Period (in this case, 201906). The purpose is to calculate the varian...
Please use the same link as above.
Best
D.
OK. So you need another table (created in PQ) that for each quality will store the quantities for the latest and oldest period.
I'll post a link to a file shortly.
Best
Dare
Yes, I think that should be a way to go. :-)