Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need help with matrix table.

Hi All. So I am using a matrix table in my report like below:

 

As we can see in the above picture, Account Manager - 'Aaron Siler' has 2 Opportunities, 2 opportunity values, 2 Accounts and 2 confirmation dates. Likewise Each account manager would have 'N' number of opportunities, opportunity values, accounts and confirmation dates.

So my question is, Is there a way where we can show the very first opportunity, opportunity value, account and confirmation date and the other opportunities and etc information will be shown only if the user expands them using '+' icon? Is this achievable? Any help would be much appreciated. Thank You in Advance!

3 Replies

  • NikhilChenna's avatar
    NikhilChenna
    Skilled Sharer
    3 years ago

    Hi Anonymous ,

     

    As per the screen shot given by you the drill mode is on so you are able to see all the values.

    For showing only the first one you can simple click on the drill up button which will be on the top right of the visual as shown below,

     

     

    You'll get your output from this.

     

    Regards,

    Nikhil Chenna

     

    Appreciate with a Kudos!! (Click the Thumbs Up Button)
    Did I answer your question? Mark my post as a solution!

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      hi NikhilChenna It is drilling up the entire column 

      • NikhilChenna's avatar
        NikhilChenna
        Skilled Sharer
        3 years ago

        Hi Anonymous , 

         

        Can you send me you pbix sample.

         

        Regards,

        Nikhil Chenna