Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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?
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?
Try adding the Total qualifier to the Before function: rangeavg(before total count(....) ,0,5))
Nope.
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.