Is it possible to pass the aggregated metric AMOUNT value from query 1 into query 2 that has additional fields but not the AMOUNT ? When a user makes a filter selection, the AMOUNT column should be reflected in the detail for each columns from query 2.
Table 1 has the aggregated Amount at Dim1/Dim2/Account level
Table 2 has the other fields but no Amount.
Filters to be used are: Dim1, Dim2, Account, State, County, City, Zip
Please see data set below for example. I also attached a qvw for reference.
In your qvw, for example, if you select Agriculture from Dim1, the total amount is 1000. Now, if you look for the same across state or county or zip, the total amount is always 1000; however, I'm looking for a breakdown of that 1000 by state, county, zip or whatever filter is selected.