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

Options
krishnadbr
krishnadbr Member, ALL USERS Posts: 5 Contributor

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

Comments

  • krishnadbr
    krishnadbr Member, ALL USERS Posts: 5 Contributor

    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 Member, ALL USERS Posts: 5 Contributor

    @andrewtye

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

    krishnadbr_0-1645879032774.png

    Thanks,

    Balarama Krishna