Forum Discussion
Helper Imatrix table format--i want table in below format
| 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 |
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!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
6 Replies
Pra2010Ghacurrently 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
Super User
Hi,
Share 2 tables - input table and expected result table. Share both in a format that can be pasted in an MS Excel file.
- pcoley
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! - maruthisp
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
- v-achippa
Community Support
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
