show multiple rows

[Anonymous]

I have the following data:-

table name

program code

patient count

date

and I am trying to create a report in the following format

tablename               program code                       1/1/2019     (date)                       2/2/2019 (date)   --> Headers

abc(table_name)       xyz (program code)               100 (patient count )                          200(patient count)  ---> Values

I am unable to display the program code as a differentcolumn when I use matrix, since values for only one row is displayed.

[v-yulgu-msft]

Hi @Anonymous,

---

 tablename               program code                       1/1/2019     (date)                       2/2/2019 (date)   --> Headers

abc(table_name)       xyz (program code)               100 (patient count )                          200(patient count)  ---> Values

---

To achieve above output, you just need to place [tablename] and [program code] into Matrix row, place [date] into columns and place [patient count] into values section.

I cannot understand what you said "I am unable to display the program code as a differentcolumn when I use matrix, since values for only one row is displayed.", please illustrate with sample data.

Regards,

Yuliana Gu

[Anonymous · Accepted solution]

I had to do this to make it work:-