Need help related to custom Time Dimension

Hello Everyone,

Want to create module which captures data days wise, but the challenge is the data should be Displayed in two ways.
So, If current forecast day is 6th Aug, so 1st Column named "Till Date" will be showing Summation of 1st Aug to 5th Aug and remaining days will be displayed in further columns which will sum up to "Remaining days".

Any ideas/suggestions on how to build this ?

Thanks :)

		Forecast
Revnue $	Products	Till Date	8/7/2024	8/8/2024	8/9/2024	8/10/2024	8/11/2024	8/12/2024	8/13/2024	8/14/2024	8/15/2024	8/16/2024	8/17/2024	8/18/2024	8/19/2024	8/20/2024	8/21/2024	8/22/2024	8/23/2024	8/24/2024	8/25/2024	8/26/2024	8/27/2024	8/28/2024	8/29/2024	8/30/2024	8/31/2024	Remaining Days
RevnueUSA	All Products	4.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	2.0%	50.0%
Revnue China		6.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	1.0%	25.0%
Revenue APJ		7.00%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	8.0%	200.0%

Accepted answers

All comments

seymatas1

Hi @priyanka1029,

Instead of building an Excel-like table at the back end, I built a solution with UX workarounds. Does this work?

priyanka1029

Hello @seymatas1,

In First Grid, r u using Time dimension or line item to capture first 6 days data?

seymatas1

Hi Priyanka,

I am using custom time, months, and days lists, and two subsets.

Revenue% Till Date Module:

Revenue % Forecast Module:

On the UX page, I published only the Revenue % Forecast module's two line items side by side.

I hope this helps.

Seyma 🌷🙂

priyanka1029

Hello @seymatas1,

Thanks for the solution, But not Sure every day current period date will change then previous date data will move from "Remaining days" to "Till Date". In that case how the subset are going to update .ex. Current date is 10/Apr so it's in "Remaining days" subset but tomorrow it will be in "Till Date" subset.

seymatas1

Hi Priyanka,

You can adapt this solution to your model structure. I'm not sure how the rest of your model operates but if you are using a custom day list and you have a concept like "Till Date", you should update the current date and Future Days and Historical Days subsets. You might consider Cloudworks to schedule these actions daily.

Quick Links

Can you help?

Unanswered questions

Anaplan Report page issue in the UX
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
Solution for when 2 time dimensions needed
As shown in the screenshot, each monthly amount (Jan, Feb, Mar 2024) needs to be paid down in the future months (Jan–Aug 2025). The paydown must satisfy certain conditions specific to each month between Jan and Aug 2025. If the conditions are met, the paydown can occur. For example, if $20 is available to pay in Jan 2025…
How to get live small project for learning more.
I have completed level 2 certificate still I am not confident. I want practice more, where I get small project for practice.