Show all months even if i have data for 2 months

[saumyashah90]

I have 2 months Data for Nov and Dec

But on UI i want to see all months(in a listbox).

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

when i click on nov dec data should change but when i click on others no data display

[gautik92]

go to Presentation tab uncheck supress zero values

[saumyashah90]

i dont think we have that option in list box

[Anonymous]

If in your transaction date you are having November or Dec then how you can show all the months untill and unless you have not created it mannually.

[saumyashah90]

But i need to display all the months will blank data for other months

[sasikanth]

HI,

Script level calculation

YOUR_TABLE:

Load ,

month,

filedd1,

field2,

.

.

From table1;

concatinate (YOUR_TABLE)

Load * INLINE

[

month

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

];

month field name should be same in both places

[Anonymous]

In that case first create the Master Calender of those. then only you would be able to do.

Are you getting any month except Nov or Dec in your transaction date?

[saumyashah90]

nope

[saumyashah90]

these repeats my Nov and Dec twice

[Anonymous]

That would be because of Format.

Make sure both Nov and Dec in inline function and created by you are same.