I have made a report en made a group (Name, Place, Afk), the result is like the first screenshot. I like to have in the red cels that there was also the data of the cel above, see the green cels in the second screenshot. So I don't have to do anything when exporting to EXCEL. Who can help me? Thanks in advance ![69746-screenshot1.png][1]![69739-screenshot2.png][2] [1]: /answers/storage/attachments/69746-screenshot1.png [2]: /answers/storage/attachments/69739-screenshot2.png
Hi @KnuifMBGMartin-5005 ,
Assuming [Place] group by [Name], when we create a group, a new column [Name] will be added, delete the [Name] column, and select "Delete column only". Then insert [Name]Details outside the group.
I did the test locally, you can refer to the following operations:
First I have an original table, and I have messed up the order of name and place. As shown below:
Create a group, where I set [Afk] group by [Place], [Place] group by [Name], and then delete only the column of the parent group, as shown in the following gif file:
Export to Excel file for viewing:
Hope this helps.
Regards,
Joy
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Thank you for uour quick response, and very helpful to show that in a video.
Bit now I see I forgot the most relevant detail. My problem occurs in a matrix-report. I tried your solution in my matrix report but unfortunately it is not working. Can you help me …. again?
Hi @KnuifMBGMartin-5005 ,
What is the structure of your matrix report? Could you provide some samples?
Judging from the data you provided before, I think tablix is more suitable for your needs.
Tablix has a fixed number of columns and a variable number of rows. In other words, the number of rows in the table depends on the number of result rows returned after executing the database query.
Matrix is that rows and columns are variable. The matrix displays data in a structure similar to a cross-tab or axis table. Rows and columns can be grouped.
Regards,
Joy
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi @Joyzhao-MSFT,
I sent you mine example of a matrix-report and I hope it shows to you what I finally want.
Thanks again in advande.
Martin Knuif
@Joyzhao-MSFT
Thanks for replying. You mean the table underneath? Thanks in advance.
Hi @KnuifMBGMartin-5005 ,
OK, I see. I will demonstrate as follows, please check carefully, I left blank for the month column, because it is not difficult for you.
Best Regards,
Joy
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hello @Joyzhao-MSFT It's fantastic, it works.
Can you also help me in the next case?
I want a total of all [Sum(TotalWaarde)] in every column. It seems to me simple, but everything I tried failed. I often get a total per line, but I want per column a total of all lines.
Thanks again in advance.
Hi @KnuifMBGMartin-5005 ，
Judging from the title of the case，It seems this is one question that worth to be separated in one independent thread, how do you think ?
Could you help kindly to close this thread and mark helpful answer and open a new thread so we could work on that ?
Thanks for you understanding ! :)
Best Regards,
Joy
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
6 people are following this question.
