Why my GP% chart can display Jan and Feb % ?

[paulyeo11]

Hi All

I have a table it can display monthly GP% amount.

YearMonth year 2019 2020
19 Jan 22% -
19 Feb 30% -
19 Mar 23% -
19 Apr 29% -
19 May 28% -
19 Jun 40% -
19 Jul 31% -
19 Aug 29% -
19 Sep 33% -
19 Oct 27% -
19 Nov 29% -
19 Dec 41% -
20 Jan - 28%
20 Feb - 29%

when i plot the chart , it can only display Jan and Feb ?

Paul Yeo

[paulyeo11]

Hi All

Enclosed my QVW

[prma7799]

Hi Paul ,

Could you please share some sample data with expected output.

I am not able to open your qvw file

Thanks

[paulyeo11]

Hi Sir

I have found the issue , it is due to my expression. Now work fine.

Paul

[Anil_Babu_Samineni]

The expression quite wrong to me in this section

year = {">=$(=max(year),4)"}

[paulyeo11 · Accepted solution]

Hi Sir

I have replace with below , it work fine :-

(
sum(sales)
-
sum(cost)
)
/
sum(sales)

Paul