Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm trying to average in the right most column the CSA prices of SKUs on the left. So, for example, one SKU may have three CSA prices, how do I average these three prices without removing the individual prices as a dimension?
I've tried these two formulas and neither have worked:
Avg(aggr(Avg ([Final Price]), PK_SKU))
avg({1} Final Price )
Any help would be greatly appreciated
Thanks
May be this?
= Sum(aggr(Avg ([Final Price]), PK_SKU))
How about this
Avg(TOTAL [Final Price])
or
Avg(TOTAL Aggr(Avg([Final Price]), PK_SKU))
=avg(total <PK_SKU> aggr(Avg([Final Price]), PK_SKU))