Team - I am dire need of your help for the below problem. Kindly help me with a sample query.
I've attached the excel sample.
Sheet Name: Raw Data
This is how i get the raw data (ofcourse this is just a sample, actual file will have ten's of thousand's of rows & even the levels in customer / organization / product is dynamic (as in, it may have level 1 to level 9).
Sheet Name: Needed Values
This sheet is the required value from the raw data. as in the Raw data sheet may have more than 1 level of a customer with more than 100 / so unique customer id's however we may need only 10 / as required in this sheet.
Sheet Name: Report Format
This is a sample of final output what i need to present.
Ex: Look at Needed Values sheet, it has 4 customers. Every customer need to be checked amongst the levels & then it should filter the org and then the product then sum the value in "SU" and paste the output.
Please give me a sample query. Very urgent.