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
Hello All, Is possible to Data label colours based on Legend? By default the Axis in ANPALAN steps up by 2.5K, how to manually adjust? Data labels for all legends is not displayed, possibly due to size, how to move the labels TIA
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a list…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
