Table with expand function

[showy123]

I have the following requirement

I have different batch numbers and the corresponding storage bins. Now there are batches with one storage bin which is in one table (batch number, storage bin), one row. But there are also batches that are divided into several storage bins.

Now the goal should be a table in which batch numbers and storage bins are displayed. The batch numbers that have several storage bins should be able to be opened and closed. When they are collapsed, the column should show “***”. When expanded, all storage bins.

How can this be implemented?

[Anonymous]

Your solution is so great Rupak_bi, it worked perfect!

Hi, @showy123 

 The solutions provided by Rupak_bi do work and are as follows:

If you have already fixed the issue, you can mark the Rupak_bi reply as a solution.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Rupak_bi]

Hi, @showy123 ,
Bin is string only in my example. The error you are getting because you may have renamed your existing columns and its getting duplicate. its a query related issue.  you need to implement the solution based on the columns you have in your table. 

[showy123]

[Rupak_bi · Accepted solution]

HI @showy123 

here is your solution using matrix visual

there is a small trick inside. the Bin is there in the row but here not visible. for that you need to manually hide that colum by dragging from the grid edge.

if this solves your problem, Please accept as solution.

[showy123]

Thanks,

i think this is the right way.
I tested it in my report and geht the Errormsg: "Could not resolve the QueryDefinition. The query contains at least two expessions in its select clause with identical native reference name 'Bin'"

My column Bin is string and i cant change it to int

[danextian]

Hi @showy123 

As always, please post a sample data and your expected result from that. You can see your data and you basically know what you want to happen, at least visually, but the rest of us can't.