sfeAnalyst
New member
- Joined
- May 12, 2021
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 365
Hi everyone,
I have an issue that I'm stuck with since this 2 days, actually i have a CVS file containing more than 5 millions rows with the following columns :
Idcode / Years / Months / Companies / Products / Units / sales in $.
So to analyze this data i used Power Query and i added the table to my data model.
My problem begins when i added a pivote table and i put in rows "Company + products" and in value "Units or sales in $" in my products i have blanks and i don't know where this blanks came from.
NB: The CVS file contains clean data that i receive from a big data company.
Any idea ? any solution ? I'm going crazy
Tnx by advance
I have an issue that I'm stuck with since this 2 days, actually i have a CVS file containing more than 5 millions rows with the following columns :
Idcode / Years / Months / Companies / Products / Units / sales in $.
So to analyze this data i used Power Query and i added the table to my data model.
My problem begins when i added a pivote table and i put in rows "Company + products" and in value "Units or sales in $" in my products i have blanks and i don't know where this blanks came from.
NB: The CVS file contains clean data that i receive from a big data company.
Any idea ? any solution ? I'm going crazy
Tnx by advance
Last edited: