Sum a field satisfied an filter

[danosoft]

Hi i need to count in a line chart, a field than satisfy a fiflter, esample:

if(GetFieldSelections(CD_FORNITORE)='XXX',

    Sum({<CD_FORNITORE1={"XXX"},[FORNITORE1]={'XXX SOC'}>}NRPOD)

, ''

)

CD_FORNITORE : is a field of my TABLEA (i have  a filter in a dropdown button of that

in my TABLEB i have a filed CD_FORNITORE1

so i want SUM NRPOD of my CD_FORNITORE1=xxx AND FORNITORE1=xxx soc

it must satisfy that in my TABLEB becouse in that table i need to count the NRPOD where satisty only that

[sunny_talwar]

Would you be able to share some sample data to elaborate on your issue?

[danosoft · Accepted solution]

Hi, i did it thank in this mode:

	dual((
	num(Sum({<[cd_fornitore1]={'xxx'}>}[NRPOD]),'#.##0;(#.##0);-')
	) & chr(10) & chr(10), (
	num(Sum({<[cd_fornitore1]={'xxx'}>}[NRPOD]),'#.##0;(#.##0);-')
	)),