on 2015 Aug 21 6:22 AM
Hi Mustafa,
you can check the option (hide empty rows ) in the query properties. If its not working you need to create your custom formula to display 0 or Null and apply the option.
other method to do this is by using alert. but it will be visible when you export it in Excel.
hope this will help you to decide how you want to display the data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ankush,
I don't know if this idea can help.
Have you try to put a filter on the table using :
"Current Assets is not null" ?
Regards,
Thomas.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did you check the relative options of the table to hide empty rows and rows with 0 in all measures?
-Ankush
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.