Dimensional value split into multiple column in Table view?

[devarasu07]

Hi,

Can you advise me on how to show below expected output using Straight table? Thanks

I've tried below set expression and it's not getting desired output like above.

sum({<Shop=P({<Shop={'Warehouse'}>}Product)>}SOH)

//sum( {$<Shop = P({1<Shop={'Warehouse'}>})>} SOH )

//=SUM( {<Category = P({<Category ={'WHS'}>} ) >}  SOH)

//sum({<Category={'WHS'}>}SOH)

//sum({<Shop={'Warehouse'}>}SOH)

Thanks,

Deva

[sunny_talwar · Accepted solution]

Have a look at the attached

[devarasu07]

That's you Very brilliant solution

[devarasu07]

Hi stalwar1‌

Tried to implement the same mock logic into original report and ranking not working as expected. kindly help me to advise me on this issue. Thanks

Created below kind Cal.Dimension:

=IF(Aggr(Rank(SUM({<Year={$(vCurrentYear)},Week={$(vCurrentWeek)},SoldQty={">0"}>}SoldQty),4),StoreName,ArticleNo)<=10,

aggr(RANK(sum({<Year={$(vCurrentYear)},Week={$(vCurrentWeek)},SoldQty={">0"}>}SoldQty),4),StoreName,ArticleNo))

in Expression, also if we included the Year, week filter then the below two expression is not working. just shows results as 0

Store SOH:

sum({<ShopCategory-={'WAREHOUSE'}>}soh)

WH SOH:

(Sum(TOTAL <ArticleNo>  soh)  - sum({<ShopCategory-={'WAREHOUSE'}>}soh)) *  Avg({<ShopCategory-={'WAREHOUSE'}>} 1)

[sunny_talwar]

What will be the expected output? It might help to know what is needed to help better