Oracle Transactional Business Intelligence

Products Banner

Two Pivot Tables with Different Values




I am trying to contain a report that has two pivot tables in it but with different parameters to restrict the results. I am pulling in the Expenditure Type column and want to restrict it by Expenditure Category. I want one table to show Expenditure Types by the 'Labour' value from Expenditure Category and the other table to show Expenditure Types without the 'Labour' value. Now, I can do this but only for one table, if I create another table it automatically restricts it to 'Labour' and if I change it then it changes table 1 to whatever I have changed table 2 too. Is there anyway I can manipulate the selection steps or filter the column so this conflict doesn't occur ?