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