Issue ??

[#1]

Hi Team,

My Dummy data :

Category	Type	Part	Flag	Value
A	L	P1		100
A	M	P2	X	200
A	M	P3		300
B	L	P4		400
B	M	P5	X	500
B	M	P6		600
C	L	P7		700
C	L	P8		800
C	L	P9		900
D	M	P10	X	1000
D	M	P11		1100
D	M	P12		1200

and My Expected Output :

OUTPUT
Category	Part	Value
A	P2	600
B	P5	1500
C	P7	700
C	P8	800
C	P9	900
D	P10	3300

  if Flag ='X' only then value  should be add up and part  colmun should have only that part  which is associated with Flag='X'  not all part and if Flag is not X then it should come as same as  dummy excel

[#2]

Thank you so much Gysbert Wassenaar its working fine now.,.,

In addition of this one small requirement i need.

If i select part which does not have flag value it should show zero value and if i select part which have flag value  'X'

should show value as addition of part associated with same category

Eg:

If i Select P1 (Flag=' ')should show 0 value and if i select P2(Flag='X') should show 600 value.

what should i do?

[#3]

hi Gysbert Wassenaar,

have you tried out to attempt this???

Thank you for solution its working but on part selection it is not working as i need .,.

kindly suggest what should i do ???

[Gysbert_Wassenaar]

have you tried out to attempt this???

No, I can't seem to access your document. For some reason my computer doesn't seem to have a connection to the system where you stored it.

[#5]

HI,

I had given you dummy data.

rangesum(sum({<Flag={'X'}>}aggr(sum({<Category=P({<Flag={'X'}>} Category)>} total <Category> Value),Category,Part)),sum({<Category=E({<Flag={'X'}>}Category)>}Value))  by this expression i will get my expected output but on Part selection what i want is...

If i select part which does not have flag value it should show zero value and if i select part which have flag value  'X'

should show value as addition of part associated with same category

Eg:

If i Select P1 (Flag=' ')should show 0 value and if i select P2(Flag='X') should show 600 value.

what should i do?

[Gysbert_Wassenaar]

see attached example