Forum Discussion

ritanoori's avatar
ritanoori
Icon for Resolver I rankResolver I
7 years ago
Solved

Dynamic Matrix based on filter selection

Hello Everyone, I have a matrix where rows are measures and columns are Dates "Month-Year". I want to find a way that when a month is selected in filter. Matrix will show Current Month "Selection", ...
Need Help
  • ritanoori's avatar
    ritanoori
    7 years ago

    I was able to do by using Segmentation table for dates then use VAR selection.

ritanoori's avatar
ritanoori
Icon for Resolver I rankResolver I
7 years ago

Thanks Greg, in this case I have to create a measure for each period required and that will keep adding measures to my rows which I don't want. I only want to show the four lines and coulmns changed based on selection. 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

OK, if you can provide some sample data and expected output that would help. I'm not 100% certain what your setup is in terms of calculations, etc. Are you saying that you have measures in rows? Perhaps a screen shot of how your fields are configured in your matrix. 

  • ritanoori's avatar
    ritanoori
    Icon for Resolver I rankResolver I
    7 years ago

    this is the required output

    Yes I have measures in rows and Month-Year coming from date table. 

    • ritanoori's avatar
      ritanoori
      Icon for Resolver I rankResolver I
      7 years ago

      I was able to do by using Segmentation table for dates then use VAR selection.