Forum Discussion
Solved
Sort drilldown categories in matrix rows
Howdy. I am working with a large financial data file and need to report out in a specific order. I have tried creating indexes and then sorting by column, but that doesn't seem to work (at least the ...
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