How to get all periods totals with tiem dimenson in to a target module without time dimeson.

Hi All,

I have asituation where I need to pul previous 4 years totals into another module which do not have time as dimenson. How can I achive this. My module screen shots are as below.

Blueprint view of same

The data needs to be pulled into

blueprint view of same is

Thanks for your help.

Balrama Krishna

Accepted answers

andrewtye

Hi @krishnadbr

When using TIMESUM I prefer to have a look-up module with start and end dates. That way it's dynamic and future-proofed (plus I find the relative time sometimes a struggle to get right!)

And of course if you're wanting to bring through the total ie All Periods just use [SELECT: Time.All Periods] - one of the few times when select is to be used.

Hope that helps

Andrew

All comments

andrewtye

Hi @krishnadbr

When using TIMESUM I prefer to have a look-up module with start and end dates. That way it's dynamic and future-proofed (plus I find the relative time sometimes a struggle to get right!)

And of course if you're wanting to bring through the total ie All Periods just use [SELECT: Time.All Periods] - one of the few times when select is to be used.

Hope that helps

Andrew

krishnadbr

Hi @ andrewtye

Thanks for your uick response. Yes I used and time module to keep dynamic and future-proofed.

Here I used the dual summary methods. sum, timesum over the line items.

got the values.

Please can you conform this approach is correct?

Thanks,

Balarama Krishna

krishnadbr

@andrewtye

Thank you very much, Your suggestion worked for me. The final screenshot shows as below.

Thanks,

Balarama Krishna

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
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.…