Showing data of months of different years in same table

[#1]

Hello,

I want to know a way to show data of months of different years in a same table.

I need to make a count function, in a way that in a row will be displayed data of the past year, and in another row, data of the current year.

The data format is set for DD-MM-YYYY.

Thanks for any help.

[#2]

Hi,

Try in the load to add a filed 'Year' . For example:

Load *, Year(yourDate) as RecordYear.

Then you can add RecordYear as a dimension.

You can also add a calculated dimension in the chart directly:

Year(yourDate) as DimensionYear

Regards

[vijay_iitkgp]

Hi,

You can do it in Straght table, Take Year and Month as Dimension and use Count() in you expression and in presentation Hide Year.

Hope this will help

[SunilChauhan]

see the attached file

hope this helps