Forum Discussion

Locco's avatar
Locco
Helper III
5 years ago

Split rows based on quantity

I'm trying to split rows based on a quantity value.   Each row has a quantity from 1-100. If the quantity is more than 1 I would like to split it into multiple rows. For instance if the quantity is...
Need Help
v-cazheng-msft's avatar
v-cazheng-msft
Community Support
5 years ago

Hi, Locco 

Is your problem solved? If not, can you provide some data removing sensitive data or show your expected table?

 

Best Regards,

Caiyun Zheng

Locco's avatar
Locco
Helper III
5 years ago

Hi v-cazheng-msft 

 

I am still having an issue, but I don't think I can actually do this with the current data setup. I'm going to review the data and how it is pulled to the report to see what/if changes can be made and then go from there.

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Community Support
    5 years ago

    OK. If you have problem, please let us known.

     

    Best Regards,

    Caiyun Zheng