3 Replies Latest reply on Nov 6, 2018 3:56 AM by Ombir Rathee

    need to show Category wise sub-Category wise sales in another sheet when we select a sub-category in the filter

    ravindra babu



      I want to show a comparison between Sub-Category sales and all Sub-Categories in a category. i mean: when I click on Sub-category in the filter as shown below it has to  show that Sub-category value in one sheet and all the Sub-categories values to which category that particulate Sub-category( selected in Filter) belongs to in another sheet.


      below is a example screen shot. i didn't achieved it. for understanding purpose  i showed.


      please anyone get this solution as soon as possible for me.. it a major requirement form my client.