How to achieve Matrix report with Months next to Year-total(YTD) On columns.

[praveen571]

Hi ,

I have PTD( detail data) in one table and YTD (total Year data) in another table.

I want to Create Matrix report like months as columns and Year total next to those months.

 

as shown above I have created.But I want date filter, In that case PTD Information has date YTD dosent have date .

when i choose any specific month or date range using date filter  "2016YTD" Missing.

Kindly advice me how to achieve.

Thanks ,

Praveenkumar.K

[Baskar]

Can u pls try this one.

bec i want to know data is there or not ?

did any calculation on the measure ?if yes pls share the measure.

[praveen571]

Hi Baskar,

Thanks for the response, Here is the measures I'm querying.

Could you please suggest me how to maintain these measures table to achieve that matrix.

Thanks,

Praveenkumar.K

[Baskar]

Cool,

U don't have date for YTD2016 right ? Then how it will show the result my dear friend. look the image.

[praveen571]

Hi Baskar,

Yes, your right .I'm requesting for that only how can achieve that without date....OR, I have to change my table design and how it be.

 Here, if we put date its belongs to that particular date.I have to show that data across Year.

Thanks,

Praveenkumar.K

[Baskar]

Sorry friend , U should have value on Date otherwise how we can apply the Date slicer for that row?

Technically no way and Practically also there is no logic machi.