Dataset filters

[AlexC1]

Hi,

I would like to implement a report containing two different datasets in seperate sheets. One has a field Category which i want it to be a mandatory parameter. So i make it configuring the field. But the second dataset does not have a Category field, but the app still tries the filter and shows no value at the end. Sheet actions do not work since the field is set as mandatory. Can you guide me how i can get over this issue? Thx

[joaopaulo_delco]

Hi @AlexC1 !

       Can you post a screenshot of your data model? It would be good to understand better.

[AlexC1]

Looks like this. Thx 

[joaopaulo_delco · Accepted solution]

Hi @AlexC1 !

I understand that you need two independent tables, right?

So, if you need tables in which the filters do not affect the others tables you have to build tables with different fields names.  

Something like below:

[DataSet1]:
Load * Inline [
Region, Country, Category, Revenue, Budget
LATAM, Brazil, Cat1, 100, 500
LATAM, Argentina, Cat2, 200, 200
US, United States, Cat5, 300, 50 
];



[DataSet2]:
Load * Inline [
RegionSet2, CountrySet2, HeadCount
LATAM, Brazil, 50
US, United States, 35
];

[AlexC1 · Accepted solution]

Solved my main issue, thx