Ignore Dimensions

[ajithsachin]

Hi All,

     I have a table like this.

    now i need to show one straight table like

     

    How to add the last column Ware house stock.

    Can anybody help please.

Regards,

Ajith

[alexandros17]

in the dimension write at the place of Branch:

If(Branch='WhareHouse', Null(), Branch) then check the box "Suppress Null Values"

in the expressions write a new one:

Sum({$ <Branch = {'WhareHouse'}>} TOTAL [Current Stock])

let me know

[ajithsachin]

Hi Alessandro Saccone,

     Thanks for the reply.

     This will work fine if only one item is there. My case i have multiple items. So i will get same stock fro all the items.

     i need item wise ware house stock.

Regards,

Ajith

[PrashantSangle]

Hi,

Try like

Use CalculatedDimension

if(not wildmatch(Branch,'WareHouse'),Branch)

then check supress Null Values

And Use two expression

1->sum(Current Stock)

2->Sum({<Branch="WareHouse">}Total Current Stock)

Regards

[#5]

Hi Ajith,

Please find the attachment.

Warm Regards,

Joshmi

[ajithsachin]

Hi Max Dreamer,

      Thanks.

      This will work only if there is one item.

       In case of multiple items this wont work.

Regards,

Ajith

[ajithsachin]

Hi All,

     Let me put my question in this way.

     My table contains data like this.

         

     and need result like this

    

     I think now the question is clear.

Regards,

Ajith

[manojkulkarni]

for warehouse, use aggr() on item, so it would return expected result.

[ajithsachin]

Hi Manoj,

     If you don't mind can you just add that expression and give.