I have a data cube that uses a Top/Bottom block to report the most-recent entry from a table of transactions. That is, it sorts by date, groups by ID, and then gives me the most recent transaction for each ID by only returning the Top 1.
On the dashboard, I want to filter the results by other columns. So I added a filter. Not important, but the filter allows the user to pick which category of transactions they see.
Well I just learned that the filter on the dash is superseding the one in the cube. That is, when I pick a category, it goes and gets all transactions that match, THEN gets the most recent. I can’t have that.
I need it to FIRST get the most recent (Top/Bottom in the cube) and THEN filter by category on the dash.
How can I set it to do these in order? (I cannot do warehousing, I thought of that already.)