Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Question about how to make matrix date drill down column by column

Hi Everyone,   My matrix hierarchy is: Group     Project_Grouping            Product After I dragged them to column and clicked the rightmost double arrow twice, they displayed progressively as...
Need Help
ketan10's avatar
ketan10
Icon for Advocate III rankAdvocate III
9 years ago

Hi Anonymous,

you could probably use one or two of levels in the hierarchy as filters and then show the third level in a table.
Ex: In your situation Group & Project_Grouping could be used as filters. This would give the end user more flexibility to control the data at his/her end. 
Else, if you could provide me a sample file of your dataset I could check it at my end.

Regards,
Ketan!

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Ketan,

 

Thanks for your help! That's a good way to solve this question now.

However, sometimes customers need us to sent table which format is similar as before. The former table is a povit table made by Excel. They can drill down column by column, but they can't be refreshed automatically. So we still need to learn how to drill down column by column.

I am sorry that I don't know how to import the file to community. Could you provide me your email address or the way to import file to community? Thank you very much!

 

Regards,

Kelly

  • ketan10's avatar
    ketan10
    Icon for Advocate III rankAdvocate III
    9 years ago

    Hi Anonymous

    Here is my email address: [email protected]
    You can mail me the issue in detail. Will try my best to solve it. 

    Cheers,
    Ketan!

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi Anonymous,

         

        Great to hear the problem got resolved! Could you accept your reply above as solution to close this thread? :smileyhappy:

         

        Regards