7 Replies Latest reply on Jul 26, 2018 9:55 PM by Saharat Sakulsaowapakkul

Create AVG[Sales] of [Store Name] whose [Bkk Upc] = "BKK"

Hi All

I have Dimensions of store, its location whether in "BKK" or "UPC" and measure sales

I want to create FIXED value of measure under logic "Average sales of store within BKK"

In other word, I want a fix measure of value 2,555,971 where ever its dimensions are

but (2,555,971 also have to be adjusted according to data lake)

You may kindly give me a HOW TO or else revise me an attached workbook.

• 1. Re: Create AVG[Sales] of [Store Name] whose [Bkk Upc] = "BKK"

I'm not entirely sure I understand what you're trying to do, but here are a couple of calculated fields which may help.

BKK Sales

// Sales only for BKK

IF [Bkk Upc]="BKK" THEN

[Sales]

END

Fixed BKK Sales

// Fixed average sales for BKK.

{FIXED : AVG([BKK Sales])}

See attached workbook.

1 of 1 people found this helpful
• 2. Re: Create AVG[Sales] of [Store Name] whose [Bkk Upc] = "BKK"

Hi, just following up on this to see if we've addressed your question or you have additional questions. Please advise.

• 3. Re: Create AVG[Sales] of [Store Name] whose [Bkk Upc] = "BKK"

Ken's ( Ken Flerlage) solutions works. However, one additional way to simplify this is to do it all in one calculation. It is not mentioned in many positing but you can include data restrictions in your LOD expressions.

You can use   { FIXED [Bkk Upc] = "BKK" : AVG([SALES]) }

G

• 4. Re: Create AVG[Sales] of [Store Name] whose [Bkk Upc] = "BKK"

DONE Thx both of you

• 5. Re: Create AVG[Sales] of [Store Name] whose [Bkk Upc] = "BKK"

I cannot find "Correct Answer" as usual. Could you please kindly marked them as done ?

• 6. Re: Create AVG[Sales] of [Store Name] whose [Bkk Upc] = "BKK"

If you click on the title of your post, Create AVG[Sales] of [Store Name] whose [Bkk Upc] = "BKK" , then scroll down, you should see a "correct answer" option below each response.

• 7. Re: Create AVG[Sales] of [Store Name] whose [Bkk Upc] = "BKK"

Found it thanks a lot