cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Matrix Visualization: Hide Subtotals with a Blank Description

My data set it is using a hiarchal structure that does not require a value in each level of the hiarchy.  This causes several subtotal line to appear as blank lines in the matrix and add extra subtotals that arn't needed. Is there any way to hide subtotal rows with a blank description.

 

Here is a sample of the output.2019-01-23_11-00-01.jpg

 

 

 

4 REPLIES 4
v-piga-msft Resident Rockstar
Resident Rockstar

Re: Matrix Visualization: Hide Subtotals with a Blank Description

Hi @Anonymous,

 

By my tests, if you set the value like below in visual level filter then you could achieve your desired output.

 

matrix.png

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: Matrix Visualization: Hide Subtotals with a Blank Description

Thank you for your reply Cherry, This solution doesn't really work for my issue.

In my data set I don't have any lines with 0 values, but I do have lines with missing values in L3, L4, and L5 header.  Here is a sample of what the data looks like:

 

2019-01-24_10-44-57.jpg

 

The problem comes in because not ever line has a value for L3, L4, L5, but some do. Since I'm grouping the rows by that field it will used the blank value in there and treat it as if there was a value.

v-piga-msft Resident Rockstar
Resident Rockstar

Re: Matrix Visualization: Hide Subtotals with a Blank Description

Hi @Anonymous,

 

If I understand your requirement correctly that you want to hide the rows highlight in red?

 

remove the row highlight in red.png

 

If it is, you could use the solution I mentioned for the first reply, may be you could try is not blank.

 

is not blank.PNG

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Anonymous
Not applicable

Re: Matrix Visualization: Hide Subtotals with a Blank Description

Not quite, I'm tying to hide the following lines outlined in red.

2019-01-23_11-00-012.jpg

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors