Selection should not effect ?

[gauravgg]

Hi

I have the following two expression

count(distinct{<Part={"=count(Part)=Max(TOTAL Aggr(Count(Part),Part))"}>}Part)

count(Aggr(if(Count(DISTINCT [FG Desc]&PLANT) =1,Part),Part))

I dont want the effect of selection for a perticular field on that expressions

can anyone help me

thanks in Advance

[Kushal_Chawda]

for 1st expression try below

count(distinct aggr( if(count({1}Part)=Max({1} TOTAL Aggr(Count({1}Part),only({1}Part))),only{{1}Part)),only{{1}Part)))

[Kushal_Chawda]

sunny seems like there is calculated dimension as well in chart

[sunny_talwar]

That's what I wonder... is this a calculated dimension here?

[gauravgg]

Hi sunny

I have a  composite field (i.e Model &'-'& Plant) in dimension which is created on the fly

this Model and Plant field are in two different table.

[Kushal_Chawda]

may be use below in dimension and expression suggested above should work

=aggr(only({1}Model),Model) &'-'& aggr(only({1}Plant),Plant)