Forum Discussion
Sort drilldown categories in matrix rows
Hi FalconBudget ,
Assuming that your revenue / Costs are columns in your data.
Why don't you add a table with the following format:
Index Category Detail 1 Revenue Miscellaneous Revenues 2 Revenue Charges for Services 3 Revenue Intergovernmental Revenues 4 Revenue Licenses & Permits 5 Revenue Fines & Forfiets 6 Revenue Taxes 7 Revenue Cash Balance 8 Revenue 9 Expenses Personnel Services 10 Expenses Maintenance & Operations 11 Expenses Fixed Costs 12 Expenses Debt Service 13 Expenses Contributions & Transfers 14 Expenses Capital Outlay 15 Expenses Reserves Then make a relationship between the last column and your data table.
Use the ID column to sort the Detail column and use this table for your matrix visual should work.
Regards,
MFelix
Hi FalconBudget ,
Assuming that your revenue / Costs are columns in your data.
Why don't you add a table with the following format:
| Index | Category | Detail |
| 1 | Revenue | Miscellaneous Revenues |
| 2 | Revenue | Charges for Services |
| 3 | Revenue | Intergovernmental Revenues |
| 4 | Revenue | Licenses & Permits |
| 5 | Revenue | Fines & Forfiets |
| 6 | Revenue | Taxes |
| 7 | Revenue | Cash Balance |
| 8 | Revenue | |
| 9 | Expenses | Personnel Services |
| 10 | Expenses | Maintenance & Operations |
| 11 | Expenses | Fixed Costs |
| 12 | Expenses | Debt Service |
| 13 | Expenses | Contributions & Transfers |
| 14 | Expenses | Capital Outlay |
| 15 | Expenses | Reserves |
Then make a relationship between the last column and your data table.
Use the ID column to sort the Detail column and use this table for your matrix visual should work.
Regards,
MFelix
I think I finally figured out my problem, which your comments led me to realize. I wasn't using my new table as the item in the matrix, but rather the old designation and acting confused about why it couldn't be sorted.
It worked once I tweaked the list to add more detail and pulled it in directly.
THANK YOU.