Un-Group Data

[JamesBills]

Hi Community 

I have a problem which i am really struggling with, which I'm sure can be achieved in a much simpler way.

I want to produce new lines for a value, depending on the sum of that value. Best explained in the screenshot. 

I have been trying generate rows tool but can't seem to configure it correctly.  Any help would be much appreciated!

Thanks, 

James

[Thableaus · Accepted solution]

Hi @JamesBills 

What about using Generate Rows Tool?

You create a  single row for each increment till you hit the value of Allocate Field.

Cheers,

[JamesBills]

Don't know why I couldn't sort that! Thanks

That's working now