Forum Discussion

nagaraj's avatar
nagaraj
Post Patron
6 years ago
Solved

expand collapse for column matrix

Hi,    We have a requirement to display the matrix with Column headers ( has drilldown Year -- Quarter -- Month).    I am not seeing + / - buttons for column headers.     Is it possible ?    ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi nagaraj 

    Yes, you need a hierarchy to exist in the data to be able to expand/collapse in the way you want. 

    HTH

    Michele

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi nagaraj ,

 

I don't think so. The fields can be expanded only when there is a hierarchy in the data. The hierarchy between columns does not exist and only exists between rows.

But you can try to drill on the columns.

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • nagaraj's avatar
    nagaraj
    Post Patron
    6 years ago

    You mean, that we can't achieve this functionality of Expand / Collapse using Matrix for Column headers ?

     

    OR

     

    If there is a hierarchy created for Columns, then we can use + / - for expand and collapse ?