Hello Ludwig and Pranav, I need a P&L statement with two dimensions - BU and Department. My primary dimension set contains these two. Seconday dimension set is main-account set. (do I need seconday?).
Here is my set up - Primary dimension set is “BU+Dept”; Seconday - Main-account Set; In the set up - I use the row definition for secondary dimension set.
I have 4 columns - Business Unit, Department, Account name and Current Year
Account name - secondary dimension set name;
current year - current
what do I put for Business Unit and Department? Its bit confusing to generate per dimension.
appreciate your help