Table only not working fine when current month no data.

[paulyeo11]

Hi All

Table 1 working fine for last 5 year. with out any issue.

But then every month first few day , it will have some trouble. Ref to table 2 ,

notice that 2016 only have Jan & Feb sales. But Table 1 display March sales = Rm122k ,

but actually it is Feb sales ref to table 2, When March data come in Table issue will solve,

Table 1 issue will be resolve when march data come in next few day.

May i know it there any solution ?

Paul

[deepakqlikview_123]

after supressing null values ur all values are disappearing in a chart

[paulyeo11]

Hi Deepak

I try to supressing null values on Table 1 dimension , but the march sales still display there.

Paul

[Anonymous]

you create the fiscal year calendar may be your problem is sloved

[paulyeo11]

Hi Vsudhakar

So you mean i try to make the label display change , not to display march , but the fact is now is march.

Or your suggestion is i change the expression , don't use month_n approach ? instead using SET analysis ?

Am i right ?

Paul