Can I have tabular objects which return different columns and have sort of a union which insted of giving more rows, give me all the columns in the tabular objects? In other words I am trying to get hte columns in my report from different tabular objects (or queries if possible) so that I can apply a filter on each of them individually.
Thanks for any suggestions.
I do not have this issue anymore. I changed my table structure which takes care of the problem. This can be considered closed.
Well anyhow u could have used two tabular models inside one tabular model. Put the filters on individual tabular model and select the columns u want for the report from the two tabular model.
Srik