nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is there anyway to omit weekly summary when export or hide weekly summary

HarishBabu

Hello, Is there anyway to hide the weekly summary level when export. when i check omit summary it also omit monthly levels
Select levels to sow is also disabled

Accepted answers

ManjunathKN

Hi @HarishBabu

Let me know if below solution works,

Create a filter in system module to exclude weeks and include days and months and apply it across in your target module to export.

Ratio summary is Months/Constant for weeks and Weeks/constant for Days.

Thanks,
Manjunath

pyrypeura

Hi @HarishBabu ,

While @ManjunathKN solution will work there is simpler way to create needed filter when working with time dimensions. Please see screenshots and explanations below.

With three line items where two are help line items and third one is final filter to use for time dimension. For helper line items formula is TRUE and for first one time is set to days and for second one to months and Summary is set to None. Last one formula is two helper lines combined with OR and summary set to true.

This will result in a boolean which is true for days and months but not for weeks. You can use this boolean to filter your view.

Best regards,

Pyry Peura

All comments

jagadishdash

@HarishBabu

Pivot the time scale to column then select level to show option will visible then you can select there, after that you can pivot and save the view as per your requirement.

Try this it may got your expectation.

Thanks,

Jagadish Dash

HarishBabu

@jagadishdash
Unfortunately It's not working for me. I am using Calendar type as week 4,5,4.
Thanks for you support.

ManjunathKN

Hi @HarishBabu,

you mean to say that you need to hide weekly summary and not monthly summary right.

ManjunathKN

Hi @HarishBabu

Let me know if below solution works,

Create a filter in system module to exclude weeks and include days and months and apply it across in your target module to export.

Ratio summary is Months/Constant for weeks and Weeks/constant for Days.

Thanks,
Manjunath

pyrypeura

Hi @HarishBabu ,

While @ManjunathKN solution will work there is simpler way to create needed filter when working with time dimensions. Please see screenshots and explanations below.

This will result in a boolean which is true for days and months but not for weeks. You can use this boolean to filter your view.

Best regards,

Pyry Peura

ManjunathKN

@pyrypeura

yeah! I dont know how I missed that! 😉

Thanks

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan Toolkit: side panel for model details, exports and model lock tracking
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
How to handle an Entity Structure change effective from January 2026 in Anaplan Consolidation & Repo
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
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…