Forum Discussion

CetinT's avatar
CetinT
Frequent Visitor
4 years ago
Solved

Temp Table

Hi,   I want to crate a temp table for my calculation. You can find smaple data below. When I filter "MONTH" I want to see all "ITEM" names but I want to see only total of buyed items "QTY" and "AM...
Need Help
Show and Tell
  • davehus's avatar
    davehus
    4 years ago

    Hi CetinT ,

     

    See if the attached example will help. Bare in mind that you will need to change the month in the temp table as this is calculated in memory and not on the fly. I've created a table called summarized using and then another called summarized product. I've used lookupvalue so that you get the null values you need also.

     

    HTH

     

    Did I help you today? Please accept my solution and hit the Kudos button.

davehus's avatar
davehus
Memorable Member
4 years ago

Hi CetinT ,

 

See if the attached example will help. Bare in mind that you will need to change the month in the temp table as this is calculated in memory and not on the fly. I've created a table called summarized using and then another called summarized product. I've used lookupvalue so that you get the null values you need also.

 

HTH

 

Did I help you today? Please accept my solution and hit the Kudos button.

  • CetinT's avatar
    CetinT
    Frequent Visitor
    4 years ago

    Thank you davehus . Good solution. 

    • davehus's avatar
      davehus
      Memorable Member
      4 years ago

      Very Welcome. 🙂

      • CetinT's avatar
        CetinT
        Frequent Visitor
        4 years ago

        Hi davehus ,

         

        I have another question about this ğŸ™„. If I want to make virtual table in memory or on the fly (your description) Ho can I do it?