I want to create an exact view as shown in the attached excel where product information is only given for the latest Financial Year. Is there a way to create such a custom view?
It is doable, please refer to below example from super store. But the solution will various depending on your data structure.
If you can provide a sample raw data, it will be easier to provide solution.
Retrieving data ...