Forum Discussion

mohan_g_das1986's avatar
mohan_g_das1986
Icon for Helper III rankHelper III
6 years ago

Matrix table help to add measure as column

Hi,   This is what i wanted to show in my matrix table, 3 measures & Program I am able to show it. Now the requirement is to show what is my target against each measure & what is the delta between ...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi mohan_g_das1986 ,

 

How is you data setup? How are you picking up the values for each measure?

 

Also how is the Target Table related with the other values?

 

Believe that you need to create a two disconnected tables with your measures and programs + target that then will make the calculation based on the selected measures, but without details about your data is dificcult to give you more directions.

 

Can you share a sample file?

mohan_g_das1986's avatar
mohan_g_das1986
Icon for Helper III rankHelper III
6 years ago

Target File - the connection is Year in claims & Target file. I am not able to add the excel file. adding a screenshot of sample data. 

 

Now I wanted to show target & What is pending as well in the same matrix table. Along with Actuals for the year