We have two Global Dimesnions (State and District) Some of the Dimensions have not been used but will be used later. How do get the report to eliminate dimension with zero values.
Thanks
Keisha
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Keisha,
Some tables have a field for "Global Dimension 1 Code" and "Global Dimension 2 Code". If those fields exist, you can just filter by them for "<>0" or "<>''" (depending on whether you want to eliminate zero values or blank values - blanks are represented by 2 single quotes). Jet also supports filtering by the dimension name directly. Just type the name of the dimension and then the filter value for blanks or zeroes.
Regards,
Hughes
Please sign in to leave a comment.