Hi all, Dean Harper here, Managing Consultant for AMCO Solutions UK and
Ireland. I have been hoping for this forum to be created for 3 years, so
very glad to be here! Looking forward to sharing ideas and keeping up to
date with everybody!
In the simplest terms you can use the origin dimension to break out the
data, so if you had say accounts in the rows, the adding
o#beforeadj.base to the columns would then show you the data layer up
via each of forms and import, the drill down option...
You can start fully expanded or fully collapsed as per your choice using
this setting (pic below). Collapse all will allow you to expand down
from the top as desired. This is selectable in the default column/row
intersection box in column/row setting...