I have built an App with several sheets.
In sheet 1 i want to see all my data over all months
On sheet 2 i want to see only the last/current data in my pivot table/table.
How would I achieve this? I have not been able to find any property/filter restricting the data i load into the table.
I hope that i can achieve this without adding multiple instances of the same table in the load script, and applying when loading data.