Dimension need to neglet

[ajithsachin]

Hi All,

     My table contains data like this.

         

     and need result like this

    

       actually i need to neglect the dimension to bring the ware house stock.

Regards,

Ajith

[alexandros17 · Accepted solution]

Use this expression for the Warehouse stock column:

Agg(NODISTINCT Sum({$ <Branch={'WareHouse'}>} Stock), Item)

and in the dimension write:

If(Branch <> 'WareHouse', Branch, Null())

and check the "Suppress Null Value" box

let me know

[ajithsachin]

Thank u very much..