I have two text tables showing the percent of totals in each table based on the stock. The first one is the material number and the second one is the DC code wise.
I am using the total function in both tables to get the percent. This works well. But, the problem comes when there is actions. When I click on the material number in the first table the denominator changes to that particular material. But, we need the total in both the tables to remain same. Also, the totals have to be changed based on filters.
I tried using rawsql queries, but the totals never change based on filters. Can you help me please...!!