Rows to be displayed as individual rows in table form in report template

I have a read-only table with the following structure

3X_c_e_ce750148703c9d58a5f307d8068c225dc80bc67b.png

I’m working on a report that needs to email this information as it is in the same format at regular interval. Also, I don’t want to create a pdf of this data but would like to have the same displayed as part of email body.
If I use the Select or List expression, that displays the data in one line separated by commas i.e

<<LIST(DNote_Summary[Customer], DNote_Summary[sum Counter])>>

displays following result

Customer 1 , Customer 2 , Customer 3 , Customer 4 , Customer 5 , Customer 6 , Customer 7 , Customer 8 , Customer 1 , 3 , 1 , 1 , 20 , 23 , 1 , 10 , 2 , 6

What is the way out that this information can be displayed in table format within email body as per the above snapshot

Solved Solved
0 7 267
1 ACCEPTED SOLUTION

Please try with a template something like below

View solution in original post

7 REPLIES 7
Top Labels in this Space