Hi everyone,
I am working on a capital project report within Application Studio. One of our dimensions is dedicated to projects and there is an attribute that reflects whether a project is active or inactive. For my report, I only want to show a total for active projects. Is there a way to retrieve data attributable to active projects via a cellget and some unique syntax that defines the project dimension attribute or some other method?
In my scenario, I am looking at projects at top level so filter doesn't see what children are active or inactive so that didn't seem to work. Unless, there is an option here that I may have missed? I could use a sum of base level data but there are a lot of rows. This affects report performance and the report itself becomes unwieldy.
Thanks in advance!
Jose
