Getting Monthly and Quarterly totals in Weekly model

DeepakK · 2023-03-16T01:22:48+00:00

There was an error rendering this rich post.

Hello all,

I'm building a model with a weekly time scale. The client wants to see the Monthly and quarter totals also. Do you have any suggestions on how to get these totals?

I created time filters to get a Month and also manually did a Quarter line item. But when I do a lookup, it doesn't come through.

MOnth and Qtr totals.png

Accepted answers

All comments

rob_marshall

@DeepakK

Are you using the native time functionality or are you using a custom time list?

DeepakK

@rob_marshall I'm using a custom Time functionality. We are converting the "W/C 12 Jan 23" label into a 1/12/23 time format. This is merely for the labels in dashboards.

Does that make it harder?

I used a Saved view from Time filters to create this list. Then added properties to it. I can use that Week Lookup to bring details from Native time modules to custom time ones.

rob_marshall

@DeepakK

Do you have the months and quarters defined in your list? If not, why not as you would be able to use the aggregation of weeks rolling up to months rolling up to quarters rolling up to years.

DeepakK

@rob_marshall

Do you mean I should add List properties in the Report Weeks for Month and Quarter?

rob_marshall

@DeepakK

Not properties, but parents so the weeks roll up to months which roll up to quarters which roll up to year.

DeepakK

Oh that's an interesting idea. Let me try that out.

DeepakK

@rob_marshall

Your idea worked great! Thank you so much. I added quarter and years as parents and the totals automatically roll up. I can also create grids where I only show quarter / years.

A follow up: How could I get a YOY comparison or a Q1 2023 to Q1 2022 comparison? Any thoughts on that?

Appreciate your help.

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