Requirement ragarding Report: 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, like if an account has taken couple of subscription in 2017, 2018, so I need only 2018 should appear.
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.
Can we achieve that?