1 Reply Latest reply on Jul 19, 2018 5:56 AM by Vijay Kulkarni

    Top N products in a year and also to work with applied filters

    Ben Broadhead

      Hello

       

      I have created a top 20 in/out set for our products but would like it to work so it shows top 20 products in 2018 but also shows how those product performed last year too.


      I would also like to have a total for the rest of the products to show grand total performance year on year.

       

       

      Do I need a formula to do this?

       

       

      I've applied filters to context and that seems to work for using multiple filters the main issue is top 20 in 2018.

       

      Thanks for any help