Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Hi Ajith,
Please find the attachment.
Warm Regards,
Joshmi
Hi Max Dreamer,
Thanks.
This will work only if there is one item.
In case of multiple items this wont work.
Regards,
Ajith
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
for warehouse, use aggr() on item, so it would return expected result.
Hi Manoj,
If you don't mind can you just add that expression and give.