Forum Discussion
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...
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.
