Show Vs Hide

It would be very useful to add a simple tickbox to choose whether to show or hide a row or column. If often find it useful to hide as much as possible when searching for bugs, going thru row by row would be much easier with a tickbox.

Accepted answers

PrevContributor

You can do that to the extend the row or column is from a line item. Add a Boolean formatted line and use the filter to filter out the data if the box is checked.

All comments

PrevContributor

You can do that to the extend the row or column is from a line item. Add a Boolean formatted line and use the filter to filter out the data if the box is checked.

PrevContributor

I think the solution here is only applicable to if the hide/show is for filtering. We have a situtaion where we like to show few line items only for few membes of a dimension while rest of the line items for other members of that dimension e.g.

lets say there are 2 dimensions - Regions and Products. Products have couple of properties such as Type, SKU#.

Product
Product1 (Type1, 001)
Product2 (Type2, 002)
Product3 (Type3, 003)
Product4 (Type4, 004)

Region
None
North
South
West
East

We create a module that captures Sold Amount as line item for each region and product respectively. Now we want to have a report or view that can show data in this format -

                                None              |                         North           |                  South                  |                 West                  |             East
                     Type         SKU#       |                    Sold Amount       |                  Sold Amount      |                Sold Amount      |            Sold Amount
________________________________________________________________________________________________________________________
Product1      Type1        001                             100                                             200                                      150                                    0
Product2      Type2        002                             400                                             200                                      150                                    0
Product3      Type3        003                             300                                             200                                      150                                    0
Product4      Type4        004                             0                                             200                                      150                                    0

Now we can get Type and SKU# also as line item to display along with Sold Amount (both Region and Line Items in Columns) and then hide Sold Amount for None Region and one by one (since you can either do selected or all) hide Type and SKU# for all regions other than None. Above example is easy to handle but not manageable if product and region list is very long and the properties we want to show are also many more than just 2. If there is a way to select all that we want to show or hide as check box or as list to select from that will make such views possible to work with.

PrevContributor

At minimum add for Hide - All Except Selected.

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385