General OBIEE

Get Involved. Join the Conversation.

Topic

    Aaron Leggett
    Two Pivot Tables with Different Values
    Topic posted June 19, 2017 by Aaron LeggettGold Trophy: 10,000+ Points, tagged Analyses, Customizing Layout, Customizing Reports, OBI Answers, OBIEE Answers, OTBI, Public Sector, Report Layouts, Reports 
    59 Views
    Title:
    Two Pivot Tables with Different Values
    Content:

    Hi 

    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 ?