Forum Discussion
Summarize table by Year
Hi Guys, Sorry if this question seems noobish. I have the following shaped data policy number product_code lob_description Date GWP x1 O MARINE 1/1/2024 20 x2 A HULL 1/1/...
Hi Anonymous ,
You can achieve your desired output by using the Matrix visual. Start by expanding the row headers using the double arrow icon highlighted in green, then set the layout to 'Outline' as shown below.
I have attached an example pbix file.
Best regards,
Or do you know how to remove the gray repeating 'total' rows below: