1) I have created a system module but while creating the line items created are in rows, but I want them in columns. how to proceed to this.
Hi Kunal,
Click the pivot option highlighted in red in above image, in the pop drag and drop the linitem tab into columns and the List into Rows.
Hope this helps
~Abhi
Click on the Pivot button highlighted by @abhi1017
And then to save the module view. Go to View -> Save
tick this option and hit the save button
Regards,
Anirudh
@anirudh Thanks.
@kunal_311 The module view need to be saved as highlighted by @anirudh else you might see the existing view once the module is closed and revisited.
hi @kunal_311
In the grid view of the module, there is an icon for pivot,
This enables you to pivot i.e change view of the dimensions, just drag line items from rows to columns as shown
Then you can save it by view, save as default
Hi Anaplanners, I’m working with a calculation module (Module A) that is dimensioned by a concatenated list, Time, and Native Versions. In this module, I am performing a subtraction using values from another module (Module B), which is dimensioned by Native Versions and a different concatenated list. The two concatenated…
I am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in a…
I have a selective access cost center list in a flat format that contains multiple hierarchy levels. I need to assign more than one cost center parent to a single user. While this can be done manually, I would like to know if there is a way to import this through a CSV file instead. Could you please confirm if this is…
