Pivot table chart displaying data for two different source types
I am trying 2 pivot table charts for 2 different sources of trasactions. The data all comes from one SQL statement. Basically one would be source = GL (General Ledger) and the other source = PA (Project Accounting). However, when I filter on one source both pivot tables reflect those values. I can't get them to show GL and PA. I remember set analysis from my training. Would this be a case where'd I'd use that? I just want to hard code the source type for each. The expression used is very straight forward Sum(Amount), so I want the Sum(Amount) for GL and Sum(Amount) for PA. Thanks!
