I have a drilldown scenario from one table to another one.
For example, I have the following fields in a table named Databases
Run_Date ,Category ,DBname ,Used_space
I have another table with below fields
Run_Date ,DBname ,TableName ,Used_Space
I have a drilldown group that has below directions
Category-->Databases(Same table)-->tables(Another table). I actuallly have a graph, where i show (Category/Database/Table) and same expression (Sum(Used_Space)) for all of these
I want to use only one measure Sum(Used_Space), so that no matter where am i in the drilldown group, the correct used space is calculated.
Now i want that the two tables be connected by Run_Date and DBname. I dont want them to have any links between used_space field. I cannot rename this field since this is the measure i will use in my expression. Since only one name can be used for all the drilldown group, therefore i cannot rename this field in either tables. but still i do not want that these tables have any link
Is it possible to use the same fields in both tables but still no link. or if it is not possible, then is there any alternative way?
It looks like all the data is contained in your second table, except for Category. Assuming the Category does not change over time, you could load your entire second table, and the distinct values of DBname and Category from the first table, thereby linking the two tables only by DBname.
