Greetings. I have a chart with a dimension of "Project Name". I have the following expressions: Project No,; Alloc Code; Type; Past three years aggregated individually; Aggregate Total;Percent of Project.
In some rows Project No, Alloc Code and Type do not display. I have created a table box with Project No and Project name. If I search the table box for any of the projects with non displayed fields in the chart , the chart then displays the three fields which were not previously displayed.
How can I get the three intermittantly displayed fields to display always?
If you don't specify an aggregation function in an expression (like sum,count, max etc) then the only() function is used. The only() function can only return a value if only one value exists for the dimension values of that row. If more values exists then null is returned. It sounds like this is happening in your case.
Thank you for your assistance. While I was attempting to use your solution, I stumbled across the answer. I moved the fields that were intermittent from expressions to dimensions and it works fine now.