Hi,
I have created a table with outline as shown below:
Table1
Load
UniqueID,
'Year Forecast' as Dimension
Resident main;
Left Join(Table1)
Temp:
Load
UniqueID,
Manager1,
Manager2,
Manager3
Resident Table2;
Temp table is pulling the mentioned fields from another table called Table2 using Resident Load.
In the front end, I am building a Straight Chart with
'Dimension' as my Dimension
&
Expression, which is a sum of three different fields ( sum(field1) + sum(field2) + sum(field3)).
But I don't see the expression validating properly. I only get the value of sum(field1) in the chart.
Surprisingly, when I used the same expression in a Text Box, I see the right value.
What might be the issue here? It's literally the same fields and same expression. Then why do I see the correct value in the textbox but not in the chart?
Could it be the dimension?
I really appreciate it if someone answers it ASAP as I am stuck at this issue for a long time now and my next operation depends on building this.
