w/ Calculated Dimensions, what should expression look like?

[#1]

Hello,

Hi,

I'm trying to display loyalty by the latest year puchased vs. the number of years purchased.

I have 2 calculated dimensions in a pivot table:

=aggr(count(distinct Year),GrpEnt)

=aggr(max (Year),GrpEnt)

So, how should my expression look ?

count(aggr(max(Year),GrpEnt)) gives me a number that's in the ballpark, but Im not sure it's right?

I'd appreciate any help.

Thanks - Tim

[pover · Accepted solution]

Tim,

It will probably give you the same result, but formula probably should be count(distinct GrpEnt) to how many GrpEnt are found in the grouping you making dynamically in the calculated dimensions for # of years and latest year. Since aggr() returns a list and the count returns the number of the GrpEnt 's in the list it will probably give you the same result, but it's simpler to use count(distinct GrpEnt).

Regards.

[#3]

Belated, thank you 🙂