I have another question too regarding the report only, hope I’ll be able to make you understand:
Requirement: I need the latest Subscription year on an Account.
– An Account has a custom subpanel named Subscription, where we are capturing the information of our products, subscribed by particular account, YEAR wise.
Now I need a report where I need the Account name and the latest Subscription year, i.e an account has taken couple of subscription like in 2017, 2018, so I need only 2018.
Also I don’t want to repeat the rows, like if any account has taken 3 subscription in 2019, then only one row of 2019 should appear.