Forum Discussion

alwong's avatar
alwong
New Member
10 months ago
Solved

Using a Table to call value into a filter

Hi There. I hope you are having a good day.    This is the context: The report i'm working on has "Sales Divisions" and each one is defined differently which requires me to filter them so I get the...
Need Help
Show and Tell
Tips and Tricks
  • GeraldGEmerick's avatar
    GeraldGEmerick
    10 months ago

    alwong Sure, you could do something like the following:

    Product Table = 
UNION (
  GENERATE( { "SalesDivision1" }, {Product1, Product2, Product3,...,ProductN} ),
  GENERATE( { "SalesDivision2" }, {Product1, Product2, Product3,...,ProductN} ),
  GENERATE( { "SalesDivision3" }, {Product1, Product2, Product3,...,ProductN} ),
  ...
)
  • lbendlin's avatar
    lbendlin
    10 months ago

    GeraldGEmerick   You can use CROSSJOIN  for that. 

     

    alwong you cannot dynamically create calculated tables. You can only create table variables inside measures.

Anonymous's avatar
Anonymous
Not applicable
10 months ago

Hi alwong ,

 

Thank you Ashish_Mathur and GeraldGEmerick for the response provided!


Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.


Thank you for your understanding!

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 months ago

    Hi alwong ,

     

    I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

    Thank you.