matrix table format--i want table in below format

[Pra2010Gha]

operator id	product name	return code	return reason	amount
111111
product no-3456	tv	4	damaged	1000
product no- 55	laptop	5	wrong model	400
subtotal by operator id				1400
22222
product no-1212	tv	4	damaged	2000
product no- 67	fridge	5	wrong model	200
subtotal by operator id				2200

[pcoley · Accepted solution]

@Pra2010GhaPlease try with the Matrix viz. and Format as needed: 
1. Layout and Styles presets: OUTLINE
2. Row subtotals>[on]>rows>Position: BOTTOM

I hope this helps, if so please mark it as a solution. kudos are welcome! 

[v-achippa]

Hi @Pra2010Gha,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Ashish_Mathur, @pcoley and @maruthisp for the prompt response. 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @Pra2010Gha,

We wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[maruthisp · Accepted solution]

Hi @Pra2010Gha ,
Does this help?

Looks like the matrix format which you shared is bit not sure situation for me 😞
May be you should discuss with original requirements given person to discuss further to either change the format how it should be. You can explain, whether that functionality is possible or not.

Please let me know if you have any further questions or need clarifications.

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

[pcoley · Accepted solution]

@Pra2010GhaPlease try with the Matrix viz. and Format as needed: 
1. Layout and Styles presets: OUTLINE
2. Row subtotals>[on]>rows>Position: BOTTOM

I hope this helps, if so please mark it as a solution. kudos are welcome! 

[Pra2010Gha]

currently it is in below format:The total row has value from below row

operator id	product name	return code	return reason	amount
111111	tv	4	damaged	1400
product no-3456	tv	4	damaged	1000
product no- 55	laptop	5	wrong model	400
22222	tv	4	damaged	2200
product no-1212	tv	4	damaged	2000
product no- 67	fridge	5	wrong model	200

[Ashish_Mathur]

Hi,

Share 2 tables - input table and expected result table.  Share both in a format that can be pasted in an MS Excel file.