Need help with matrix table.

[Anonymous]

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!

[NikhilChenna]

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]

hi @NikhilChenna It is drilling up the entire column 

[NikhilChenna]

Hi @Anonymous , 

Can you send me you pbix sample.

Regards,

Nikhil Chenna