Not able to sync the tables (main table and the subsidiary view)
Hello All,
I have an issue where in there is table 1 with below structure:
List (category list) | Line item1 | Line item 2 | Difference |
A1 | 12 | 5 | 7 |
A2 | 4 | 10 | -6 |
B1 | 10 | 20 | -10 |
B2 | 6 | 3 | 3 |
Total | 32 | 38 | -6 |
And there is a table 2, which is a Subsidiary view created based on a source module that is used bring the count/ values in table 1. The purpose of table 2 is to display all the information linked to each category , i.e is when I click on A1 I am able to drill down / get relevant information associated with Category A1, like wise for other category as well. But when I click on "TOTAL" row, the table 2 becomes blank with no drill down information where as I want to see the contrary.
Can someone please let me know what I am missing?
I can provide more information if required.
Answers
-
Yes, more info is required. We need to see what is the dimensionality of the subsidiary view. Also show us what is the summary of the line items.
If possible, take a screenshot of the grids on the dashboard as well.
Thanks,
Misbah
0