Hi all,
I have an existing report where a new file is getting added to the script.
I have a column Month which already exists in the report where the months are in '01,02,03 format
2.the period column comes from the new file which was added in the script. The period column is in the format
Jan,Feb,mar etc..
I have made an inline load to link this
INNER JOIN LOAD * INLINE [
period, Month
Jan, 01
Feb, 02
Mar, 03
Apr, 04
May, 05
];
Now period is one of the pivot columns of the chart and Month is the general list box of the report where it exists in every tab of the report.
The problem is facing is if i select the month list box the chart displays the correct month and its data. also when i click on the period on the chart it displays the correct month.
Additionally i have a text box which displays sum of the data based on few conditions for ex: if period = ;Jan' ..Sum({few condtions here)
Now the issue is when i click the period it shows the corrct sum.. but when i click the month it shows the wrong sum and discared the condition.
I was assuming when i link the period and month inline it should automatically understand but it doesnt.
any suggestions.