Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create a subset of a table

Hi, I have the following tabular information:   account_code name effective_from month_effective_from Year_effective_from Month-Year-effective_from effective_to month_effective_to Year_...
Need Help
  • TheoC's avatar
    TheoC
    5 years ago

    Hi Anonymous 

     

    Are you trying to create a new "table" or are you trying to filter the existing table?

     

    If it is just to filter the table based on a Slicer visual, you can drag the "Month-Year-effective_from" field into the Slicer visual and the user can simply select the Month Year such as that below. If it is not what you were after, it would be good to get some further clarification on your need if that's okay?

     

    Thanks,
    Theo 🙂

TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous 

 

Are you trying to create a new "table" or are you trying to filter the existing table?

 

If it is just to filter the table based on a Slicer visual, you can drag the "Month-Year-effective_from" field into the Slicer visual and the user can simply select the Month Year such as that below. If it is not what you were after, it would be good to get some further clarification on your need if that's okay?

 

Thanks,
Theo 🙂