Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

create group from multiple column

Hi, I have my data in this format:   Area Year Sales Amount Quantity Sold Avg Ratio Avg Receivable Avg Outstanding Avg Quantity North 2020 $3000 112 60% $2500 $500 100 South...
Need Help
Jayaselvan's avatar
Jayaselvan
Helper II
3 years ago

Hello,

Could you please share the pbi file or atleast a sample pbi file. Or atleast Source file with simple inputs. 

 

Please post expected sample output image that would be much helpful.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Jayaselvan ,

     

    the output should be like this: