Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Could you post your Data Model? (Control -T), it´s easier to help, knowing more about your data
I figured this out. Thanks!