RyanDonohue
Technical User
I have had my entire team look at the following issue and none of us can figure it out. I certainly hope you can.
I have a report with 4 crosstabs; each one gives a little more detail than the level before it. They all refer to the same query
1) Aggregate(Division) (1 Column)
2) Division (As many Columns as there are Divisions)
3) Division
Region (As many Columns as there are Regions)
4) Division
Region
Branch (As many Columns as there are Branches)
I have 3 optional cascading multiselect prompts. One for Division, Region, and Branch. Logically, if a user picks only 1 Branch, each table should show the same values. This is where I run into the issue.
Tables 1 and 4 will be identical. Table 2 will show the correct value for the first line of the crosstab (in most cases revenue). Every subsequent line will be the total of the Division ignoring the remaining filters on the query. The same is true for Table 3, but it gives me the region totals.
I think the most confusing part is that the filter is applied to these tables for the first line. Why would it be applied to one, but not all?
Is there another approach that I could use to provide the correct rollup totals based on the filters? Any suggestion would be welcome at this point.
I have a report with 4 crosstabs; each one gives a little more detail than the level before it. They all refer to the same query
1) Aggregate(Division) (1 Column)
2) Division (As many Columns as there are Divisions)
3) Division
Region (As many Columns as there are Regions)
4) Division
Region
Branch (As many Columns as there are Branches)
I have 3 optional cascading multiselect prompts. One for Division, Region, and Branch. Logically, if a user picks only 1 Branch, each table should show the same values. This is where I run into the issue.
Tables 1 and 4 will be identical. Table 2 will show the correct value for the first line of the crosstab (in most cases revenue). Every subsequent line will be the total of the Division ignoring the remaining filters on the query. The same is true for Table 3, but it gives me the region totals.
I think the most confusing part is that the filter is applied to these tables for the first line. Why would it be applied to one, but not all?
Is there another approach that I could use to provide the correct rollup totals based on the filters? Any suggestion would be welcome at this point.