Reports (cloud) - calculations between lines of expanded segments
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?
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])