RangeAvg using dimensions

[tmumaw]

Good Morning everyone,

Simple question I'm trying to use the RangeAvg with dimensions.  For some reason it does not like my statement....any ideas.....Thanks

RangeAvg(Before(Count({<YR5_SW = {1}>}DISTINCT Total([Sold To]),0,5)),GrowthType))

[Gysbert_Wassenaar]

The RangeAvg function only averages all its arguments. It doesn't not use any arguments as dimensions like the aggr function does.  Can you explain what you're trying to do?

[tmumaw]

 I have a pivot table with years across the top and offices down the side.  I want to add another dimension to the pivot table called GrowthType.  It works fine with one dimension, but when I add the second the RangeAvg does not work.  Any ideas?

[Gysbert_Wassenaar]

Try adding the Total qualifier to the Before function: rangeavg(before total count(....) ,0,5))

[tmumaw]

Nope.

[tmumaw]

I have 3 dimensions in my pivot table one Operations Groups and the other being Offices with in the group, then across the top I have Growth Type (Organic and Non-Organic)  It works fine with either Operation Groups or Offices, but when I add both it returns zeros.