Removing financial year sum data from the chart

adarshbarodia

Hi team,

Can you please guide me how to removed the FY- 19 / 20 / 21 from the sheet and doing so will it effect my data.

I want to remove the FY-19/ 20 from this worksheet highlighted in yellow.

Regards

Adarsh

Accepted answers

jasonblinn

Hi @adarshbarodia

You can do this by applying a filter to the saved view, or by applying a filter in UX if you are using a custom view.

The filter should show only the months (You want the summary for the filter line to be set to NONE) and not the years.

Here is an example if you wanted to show all forecast periods:

Then if you are using a saved view, you can simply apply that time filter, and re-save the view.

If you are using a custom view in UX, then you can apply the filter there.

Once you are in edit mode and click "view designer" within that card:

First, Click filter:

Then apply the filter to the data accordingly. Make sure to hit the "apply" and Update at the bottom.

After either of these options, your graph should be updated accordingly.

Let me know if this is not clear.
Jason

JaredDolich

@adarshbarodia

That would seem to be a way to do this but @jasonblinn solution is better. Can you create a system module that filters out the aggregate time filters? Just create a module with your model calendar only. Create a boolean line item that equals "TRUE". <--- Bingo! that's your filter. Apply that to your chart and, like magic, the aggregates are gone. Give it another try! You've got this.

All comments

jasonblinn

Hi @adarshbarodia

You can do this by applying a filter to the saved view, or by applying a filter in UX if you are using a custom view.

The filter should show only the months (You want the summary for the filter line to be set to NONE) and not the years.

Here is an example if you wanted to show all forecast periods:

Then if you are using a saved view, you can simply apply that time filter, and re-save the view.

If you are using a custom view in UX, then you can apply the filter there.

Once you are in edit mode and click "view designer" within that card:

First, Click filter:

Then apply the filter to the data accordingly. Make sure to hit the "apply" and Update at the bottom.

After either of these options, your graph should be updated accordingly.

Let me know if this is not clear.
Jason

adarshbarodia

Hi team,

I tried to use show/hide option >Time

I choose the specific columns leaving FY 19/20/21

But the data is still visible in the line chart on right

JaredDolich

@adarshbarodia

adarshbarodia

Thank you @jasonblinn and @JaredDolich this solved my query.

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…