show dimension in chart

[narender123]

Hi All,

I have to show column in a table like.

Name     date of arrival     Agent                                  Rotation

A            1/1/2016               RAMS LTD.                      140

B            1/5/2016               VIRAJ LTD.                      370

i dont need any calculation but want to show only dimension .

Note: I have to show current month  of current year clumns only.So i cant use table box to set current year moth.

Thanks,

Narender.

[sunny_talwar]

If you can create them in script then you can create a table box. Else use a straight table.

Dimension can be Name, Agent, Rotation and then expression can be Month([date of arrival]) and Year([date of arrival])

[PrashantSangle]

Hi,

Why you dont required any expression??

To achieve your requirement

take straight table

add required dimension and then go to property -> Presentation ->untick supress zero values and untick supress missing.

[narender123]

Hi Max Dreamer,

I have to show only current month year records.

Thanks for the reply,

Narender

[sunny_talwar]

Make a selection in current MonthYear to see just those entries for current monthyear in the table box?

[narender123]

Hi Sunny,

In Expression .Both month and year together no working.

Only single is working means month only or we can say year only.

=max(year([RECEIPT_DATE]))and max(Month([RECEIPT_DATE]))  not working.

=max(year([RECEIPT_DATE])) working.

Thanks,

Narender

[PrashantSangle]

Hi,

You can achieve it by creating current Month Field either in script or in chart by calculated dimension.

Calculated Dimension like

if(Month(Date_Field)=Month(Today()),Date_Field)

and also tick supress null from dimension tab.

Note :

Calculated dimension is not recommended due to Performance issue.

Regards

[sunny_talwar · Accepted solution]

If you want to see MonthYear, I guess use MonthName() function which displays as MMM YYYY.

Max(MonthName([RECEIPT_DATE]))

MonthName(Max([RECEIPT_DATE]))

[narender123]

Hi Sunny,

Thanks you so much.

Its working.Now all records of feb 2016 is showing. Can we hide this expression means hide exression but showing current year month just like its showing records now .

Please suggest.

[sunny_talwar]

In a straight table? Yes you can. Go to presentation tab and select the expression label for the above expression and click Hide Column