Monthly data presentation

[triciad]

I'm trying to create a report as following.  I'm having trouble creating separate columns from the same fields with different date filters.  Any ideas?

Name	Level	January	February	March	April	May	June
Employee 1	Staff 1	100.00	150.00	200.00	140.00	65.00	65.00
Employee 2	Senior 1	120.00	175.00	250.00	150.00	60.00	60.00

[dax · Accepted solution]

Hi @triciad , 

I am not sure what is your expected output, you could refer to above suggestions to use Matrix to achieve this goal. You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Create a matrix.  Drag employee and level on rows and drill till the final level. The stepped Layout option is there in format option. make the off. Drag month to columns

[Anonymous]

Hi @triciad ,

You could use drill down  feature of matrix visual. And I will suggest you to put Column "Level" first and then as a Drill down column put Name. 

Regards,

Gaurav Raj Singh

Join me on LinkedIN 

If I answer your question, please mark my post as solution, this will also help others.

[Anonymous]

What do you mean separate columns? 

Can you give an example and what you have and your desired result?