Total Issue

[vipin_mishra479]

Hi All,

I have a four field F1 F1 F3 F4  where F1 F2 F3 are dimension and F4 are measure  and my data is like this

F1                        F2                        F3                               F4

BB	Property	A	10
BB	ComSet	B	20
BB	ComSet	C	30
BB	ComSet	D	40
BB	ComSet	E	20
BB	ComSet	F	10
BB	ComSet	G	21
BB	ComSet	H	25
Total			22

here i get 22 avg but i want avg only compset (F2) data

like this

BB	Property	A	10
BB	ComSet	B	20
BB	ComSet	C	30
BB	ComSet	D	40
BB	ComSet	E	20
BB	ComSet	F	10
BB	ComSet	G	21
BB	ComSet	H	25
			23.71429

How can i get this please help and here i attached my application

[antoniotiman]

Hi Vipin,

Try

Avg({<F2={'ComSet'}>} F4)

Regards,

Antonio

[vipin_mishra479]

if i use this i loss Property value

[antoniotiman · Accepted solution]

[vipin_mishra479]

Thanks Buddy....

[maxgro]

if(Dimensionality()=0, Avg({<F2={'ComSet'}>} F4), avg(F4))