web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / hide all Zero Amount A...
Small and medium business | Business Central, N...
Suggested Answer

hide all Zero Amount Accounts in Analysis View Matrix

(0) ShareShare
ReportReport
Posted on by sami khan 45

Hi all,

I have created an Analysis View with respect to Dimensions. I have hundreds of Accounts in my GL Account list. But only 15-20 GL Account Entries. Issue is that Analysis View Matrix shows all accounts with zero or GL Entry sums. How can I hide or filter Zero Values from Matrix. Any suggestion to right direction will help. I am open to AL code as well.

Regards

I have the same question (0)
  • Suggested answer
    Jyotsna NAV Profile Picture
    Jyotsna NAV 585 on at

    You can achieve that in the RDLC report using the Column and Row Visibility Property on Columns and Rows respectively.

    For example: Right-click on a row > Row Visibility >  Select 'Sjow or Hide based on an expression' > Write expression =iif(Your_Amount_Field=0,true,false) > OK

    Regards
    Jyotsna
    jyotsnanav.blogspot.com

    Don't forget to help the community by verifying my answer or at least like the suggestion if it did help in any way. It will let others know that the topic has a verified answer and was beneficial to you.

  • sami khan Profile Picture
    sami khan 45 on at

    Hi Jyotsna. Thanks for the quick response.

    I have specific requirement to do this in Analysis View. We cannot move to RDLC because we neither view specific entries on clicking nor we can toggle in the treeview as they are shown as pdf in Business Central.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 566 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 347 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 327 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans