This content has been marked as final. Show 4 replies
Is it possible to hide Null dimension from legend but include values in expression?
My chart has two dimensions: Period and cyclic group with Project and Project Type as dimensions. So you can view revenue over period by project type and project. Since all projects do not have Project Type, you will have null value in legend. However, requirement is that when there is no value in project type only Total is to be shown. And when there is value, Project Type in addition to Total is to be shown.
This is easily done with three expressions and set analysis but then I cannot use cyclic dimension. Does anyone know if there is a way to solve this?