You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Reports (cloud) - calculations between lines of expanded segments

Accepted answer
34
Views
5
Comments

Summary:

I got a request for a report showing several blocks/segments of data using each time the same variable list of entities used in the rows. Each block would cover 1 pl account. The first block is the revenue and the other blocks should show by line the percentage for that pl account against the revenue.

Is it possible to do this without the need to hardcode the entities?

Content (required):

The list of entities is now dynamic using children of selection. Using grouping functionality I managed to calculate the 57% of the COS Total Entities between two grouping blocks =>using: PERCENTOFTOTAL(absolute([A]),absolute([4,A])

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!