I have Balance sheet items, in three categories - Heading, Sub Heading and Final Disclosure.
example - this is the view i want.
Financial assests held at recurring basis (heading)
Derivatives held at trading of which(subheading)
commodities contracts(final disclosre)
Government bills/bonds (final disclosure)
Equity index/contracts (final Disclosure)
Financial assets held mandatorily for recurring basis (heading)
Financial assets not held for trading of which (subheading)
Auction rate securities (final disclo)
commodities contracts (final fisclo)
Equity index/contracts (final disclo)
government bill/bonds. (final disclo)
Note: I have put brackets infront for understanding they wont be there.
I have to put it in a fixed sequence in matrix, I have tried everything - made a sorting column for final disclosure, but it says
we can't final disclosure column by sorting columns . there can;t be more than one value in sorting column for the same value in final disclosure.
I used this DAX for sorting columns = switch ( table[heading] & "|" & table[subheading] & "|" table[final disclosure],
"Financial assests held at recurring basis|Derivatives held at trading of which|commodities contracts", 1,
.
.
. it goes long.
What else i can do , i am stuck at this point?
Now, Dataset I have in this format
| Heading | Subheading | Final disclousre | opening balance | closing balance |
| Financial assests held at recurring basis | Derivatives held at trading of which | commodities contracts | 43.9284 | 284.58 |
| Financial assets held mandatorily for recurring basis | Financial assets not held for trading of which | commodities contracts | 375.35 | 235.5 |
