5 Replies Latest reply on Jun 28, 2018 2:15 AM by Tushar More

# HI please help me in this question, Show the average sales by order for each region.  Many orders have multiple items so we need to first sum the sales for each order, then take the average of those values. by using lod's

out put should be like this, some one please help me it was so urjent for me

Thanks

Anjali

• ###### 1. Re: HI please help me in this question, Show the average sales by order for each region.  Many orders have multiple items so we need to first sum the sales for each order, then take the average of those values. by using lod's

Hi Anjali,

{FIXED [Market]:avg(

{fixed [Order ID]: SUM([Sales])})}

Thanks and please see the attached workbook.

Mavis

• ###### 2. Re: HI please help me in this question, Show the average sales by order for each region.  Many orders have multiple items so we need to first sum the sales for each order, then take the average of those values. by using lod's

Hi Anjali

Try this:

1 of 1 people found this helpful
• ###### 3. Re: HI please help me in this question, Show the average sales by order for each region.  Many orders have multiple items so we need to first sum the sales for each order, then take the average of those values. by using lod's

Thanks Tushar ,It is working fine now

Convert the date 20070425 into a date format recognized/usable by Tableau.

the output should be like this

• ###### 4. Re: HI please help me in this question, Show the average sales by order for each region.  Many orders have multiple items so we need to first sum the sales for each order, then take the average of those values. by using lod's

Hi Anjali,

MAKEDATE(int(LEFT(str([Date]),4)), int(left(MID(str([Date]),5),2)), int(RIGHT(str([Date]),2)))

Thanks and please see attached workbook.

Mavis

1 of 1 people found this helpful