Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
9 years ago
Solved

Date Imported

Hi All,    Hope you have a great day.  I have daily sale report which included around 66 rows of products name and 30 columns of date from 01 to 30. I had imported the data with series of rows a...
Show and Tell
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi Chanleakna123,

     

    What is your desired output? Could you illustrate your requirement with an example? Do you want to modify the table structure in data view? Or do you want to achieve a more readable view in report view (visualization) ?

     

    Regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi Chanleakna123,

 

What is your desired output? Could you illustrate your requirement with an example? Do you want to modify the table structure in data view? Or do you want to achieve a more readable view in report view (visualization) ?

 

Regards,
Yuliana Gu

Chanleakna123's avatar
Chanleakna123
Post Prodigy
8 years ago

Hi v-yulgu-msft

i had unpivoted the columns and rows, these consists a lots of row with what i'm doing now. I think , only this way can works. 

Your solutions was also help. 

Thanks you with Best Regards,