Urgent! Help needed in Set Analysis

[Anonymous]

Hi,

I am new with Set Analysis, and i am really stuck with something I am stuck big time and really need your help.

I am having one problem where I need your serious advise on,I have a Table

Sum( if(DWH_IM_BRANCH_ID<1000 , STOCK_QTY))

IN THE ABOVE LINE WE ARE TRYING TO ACHIEVE THE STOCK OF STORES.

BUT AS LONG AS THE CURRENT MONTH IS SELECTED IT SHOW THE VALUE SEE BELOW

BUT IF I TAKE THE CURRENT MONTH OFF THE SELECTION IT DOES NOT GET ANY STOCK SEE THE IMAGE BELOW:

AS YOU CAN SEE ABOVE ALL FIRST THREE COLUMNS ARE GONE ZERO, WHAT WE WANT THAT IRRELEVANT OF ANY SELECTION IT SHOW ALWAYS TAKE

THE CURRENT STOCK NO MATTER WHICH MONTH WE HAVE SELECTED.

Then I Used Set Analysis

sum ({$<DWH_IM_BRANCH_ID ={"<1000"}>}  STOCK_QTY)

then tried sum ({1<DWH_IM_BRANCH_ID ={"<20"}>}  STOCK_QTY)

It did the job but it was showing all 15000 Above items, i just want them to take Selection into considration but bot for the Stock_Qty.

Please Help and sorry about a long discussion Question.

[joshabbott]

So if you have just a straight table with 'Supplier' as the dimension, and 'sum({$<DWH_IM_BRANCH_ID={"<20"}, STOCK_QTY=>} STOCK_QTY)' as the expression, and you select only 1 supplier, all the suppliers still show up?

[Anonymous]

YES

[joshabbott]

Any chance you could attach your document or a part of it?

[Anonymous]

'sum({$<DWH_IM_BRANCH_ID={"<20"},Month=>} STOCK_QTY)

I tried this and Looks like its fine. Thank you so much for your Help really Appreciate that you are so helping.