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

krishnadbr
krishnadbr
in Modeling

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.

krishnadbr_0-1645803020511.jpeg

Blueprint view of same

krishnadbr_1-1645803090287.jpeg

The data needs to be pulled into

krishnadbr_2-1645803141055.jpeg

blueprint view of same is

krishnadbr_3-1645803169444.jpeg

Thanks for your help.

 

Balrama Krishna

Tagged:

Best Answer

  • andrewtye
    andrewtye
    Answer ✓

    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

Answers

  • krishnadbr
    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. 

    krishnadbr_0-1645816321028.png

    got the values. 

    krishnadbr_1-1645816378241.png

    Please can you conform this approach is correct?

     

    Thanks,

    Balarama Krishna

  • krishnadbr
    krishnadbr

    @andrewtye

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

    krishnadbr_0-1645879032774.png

    Thanks,

    Balarama Krishna

Categories