Forum Discussion

New Member

10 years ago

Solved

Analyzing data in Matrix

Hi, I am trying to analyze data in matrix, its a budget vs actual report. i have data in rows like below. Type Code Amount Actual ABC ...

Sean
10 years ago
shanjaf I think this is what you are trying to do... Just create these 4 Measures and organize as in the picture
Let me know if it works.

Community Champion

10 years ago

shanjaf I think this is what you are trying to do... Just create these 4 Measures and organize as in the picture

Let me know if it works.

New Member

10 years ago

I didn't try it, i think this will work, one more question. will that calculated field work in direct query?