min max avg

[engr_farhanqadr]

Hi Folks,

please let me know if I can get min or avg or mode of seven days data tier in different cells. see picture for clarity.

Thanks

Farhan

[sunny_talwar · Accepted solution]

I am not entirely sure, but may be using RangeAvg, RangeMin

[#3]

Hi Farhan,

Can you post a sample data set to work with?

[Kushal_Chawda]

try something like this

Create Pivot Table

Dimension:

SKU

Tier&' '&Month

Expression:

Your expression

After creating pivot table drag the needed dimension horizontally

[engr_farhanqadr]

I have posted the sample picture. you can see there

[engr_farhanqadr]

I have done all this I want the average and min from tiers data.

[engr_farhanqadr]

I did the same but I had to put all column no for rangeavg. any other way out.as whenever new tier is added i need to add to rangeavg formula.