How to remove a dimension from a pivot?

juanacevedo

Hi,

Does anybody know how to remove a dimension from a Pivot?

I need to remove "time" from the "Pages" (See below).

Thanks

Juan

Accepted answers

All comments

AntonMineev

Hi @juanacevedo!

You need to delete list from module. For time you need to change Time Scale to "Not Applicable": Снимок экрана 2021-07-21 в 17.17.30.png

Ranjitha

Hi @juanacevedo

Yeah, as @AntonMineev suggested you will have to change the Time Scale to Not Applicable.

Here are the detailed steps

i) Toggle from Regular view to Blue Print View. Click on highlighted button.

ii)Move your Horizontal bar towards right to see "Time Scale", Click on the arrow to see the dropdown.

iii) Select "Not Applicable" to remove the Time Scale from your existing module.

iv) You will get a popup message soon after the selection. Click on "ok"

v) If you want the remove the Time Scale even for line items, you can just copy and paste it.

Billings523

To remove a dimension or metric, click its delete icon. The dimension or metric is removed from the table and added to the available list. To add a new dimension, drag the dimension from the available list to the appropriate location in the row or column groups.

paycheckrecords

Quick Links

Can you help?

Unanswered questions

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…