I need to create report for 3 project in 1 table however the markets are different for all 3 project. How can I create 1 report such that if I select 1 project from drop down it should show markets for that particular project however when i change the market it shows changes the market as well.
Welcome to the eazyBI community.
In this case, you could use the “Market” dimension in rows and the “Project” dimension in pages.
If the “Nonempty” cross join is enabled and numerical measure is selected for the report (for example, “Issues created”).
Then only the markets from selected projects would be displayed.
Martins / eazyBI support