Forum Discussion
Table Sort - Can't be more than one value...
Hi Dellis81 ,
According to the screenshot, OPERATIONAL COSTS field seems to have a hierarchy which may be part of the reason why it is obviously the same field but not automatically combined.
It's a little hard for me to follow, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Eyelin - thank you for your followup again. Several days ago, I posted this response to your initial request.
PS - I am having difficulty with the PBI forum converting to Spanish vs English. I do have in my preferences to us the default US English. So, I apologize if I'm not completely getting what you need. I appreciate your help, I need to get this resolved. thanks
Thanks for your response. I understand the difficulty of understanding without the underlying file. Attached is a simplified sample file that might help in our communication. https://1drv.ms/u/s!AmBVCme14p7xqESUBs3wQudF7RY4?e=YUIfZ4
Yes, there are hierarchies. I am attempting to build an income statement utilizing the report template within our accounting software. For demo purposes, I am only including end result tables. (I imported from a live working data model)
I think this is the table we need to focus on. IncomeBalance x Ledger.
1) index to a primary table with Report headers (for example "Operational Costs")
2) Report lines to display within Report Headers ie "Seed Corn Grower Costs" or "Supplies:Diesel"
3) Within each report line, could be 1-100 accounts included. For example Supplies:Diesel has 9 differing ledgers.
4) The sort column is hte sorting order I would like to see in the report.
You will notice in the demo, for both Header and Detail tables, I have a caculcated column "adding spaces" or using hte Unichar(8203) or 8204. I had read, these two Unichars return a zero width space?