Working with LIVE data (Analysis Services)

[Anonymous]

HI everyone, I have one question and hope you can help me.

Now I am working with live data, and I have one matrix table wich one should shows "CFYTD" and "PFYTD".

But I can't show neccessary data (look in pictures below).

There was blank columns wich ones should be hide and show only two columns with current and previous date. And its will be helpfull two be third column with variance (current - previous)/ previous

Here are what I am using 

CFYTD and PFYTD are measures.

Live data don't allow "edit query", "enter data"... or use "new column", and I have only measurs.

[v-xicai · Accepted solution]

Hi @Anonymous ,

>>There was blank columns wich ones should be hide and show only two columns with current and previous date. And its will be helpfull two be third column with variance (current - previous)/ previous.

I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? Do mask sensitive data before uploading.

Best Regards,

Amy