CYMTD vs PYMTD in one single measure

[ziabobaz]

Hi,

I want to build PIVOT table using following data:

Rows: Measures

Columns: MonthYear

Measures: [Revenue]

When I choose Month and Year on the filter pane, I want the PIVOT to show me [Revenue] for:

• CYMTD in the first column
• PYMTD in the second column
• Difference in the third column

Let's say I chose MARCH and 2017. There are only 7 days with the data, the [Revenue] measure would be calculated for 1-7 days of March in 2017 vs 2016, and the difference.

So far, I was only able to create two different [Revenue] measures for CY and PY, but this does not work for me.

[shraddha_g]

In column you can give 'Year' and Month/MonthYear Dimension and for selection give Month instead of MonthYear

[OmarBenSalem]

Something like this would do it?

[ziabobaz]

I don't quite get it how it will help me with my problem. I already have MONTLY data in the layout I want.

The problem is that is can't figure out how i can get MTD numbers for the single measure and how can i get DIFFERENCE column in PIVOT (I know how to do it in table).

[OmarBenSalem]

If this does the work, I can help with it

[ziabobaz]

look great except i need to switch MOD and Measure, like in the screenshot above.

How did you make the difference measure, though?

[Anonymous]

Hi, where you able to solve this? i have the same issue, but cant work it out....

please post solution if you can

thanks Andy